home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
The World of Computer Software
/
The World of Computer Software.iso
/
vino30b.zip
/
VINOFILE.TXT
< prev
next >
Wrap
Text File
|
1992-07-01
|
195KB
|
4,489 lines
V I N O : F I L E
Cellar Master
A Wine Cellar Management System
for IBM and compatible computers
By Mark Christian
Version 3 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
The VINO:FILE Cellar Master manual is Copyright 1990, 1992
by Mark Christian. All rights reserved. This document may
not, in whole or part, be copied, photocopied, reproduced,
translated, or reduced to any electronic medium or machine
readable form without the prior written consent of the
copyright holder.
First Printing July, 1992
Credits:
VINO:FILE Cellar Master is written in Turbo Pascal and
Assembly Language using Turbo Pascal Professional and
TurboPower's Object Professional.
This manual was prepared using Microsoft Word for Windows.
Special thanks to all of the members of the ``Bacchus Wine
Forum'' on CompuServe for guidance and support. Extra
special thanks for the hard work performed by all of the
beta testers.
Trademarks:
VINO:FILE and VINO:FILE Cellar Master are trademarks of Mark
Christian.
Turbo Pascal is a trademark of Borland International.
Object Professional is a trademark of TurboPower Software.
Microsoft, Windows, Word For Windows and MS-DOS are
trademarks or registered trademarks of Microsoft
Corporation.
IBM is a registered trademark of International Business
Machines Corporation.
DESQview and Quarterdeck Extended Memory Manager are
trademarks of Quarterdeck Office Systems.
Ultravision and Laptop Ultravision are trademarks of
Personics Corporation.
ASP and the ASP logo are registered trademarks of the
Association of Shareware Professionals.
CompuServe is a trademark of CompuServe Incorporated.
Other trademarks appearing in this manual are trademarks of
their respective holders.
---------------------------------------------------------------
Preface Page i VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
LIMIT OF LIABILITY
ALL USERS OF VINO:FILE CELLAR MASTER MUST AGREE TO BE BOUND
BY THIS DISCLAIMER OF WARRANTY:
VINO:FILE CELLAR MASTER IS DISTRIBUTED AS-IS. THE
AUTHOR DISCLAIMS ALL WARRANTIES, EXPRESSED OR IMPLIED,
INCLUDING BUT NOT LIMITED TO, THE WARRANTIES OF
MERCHANTABILITY AND OF FITNESS FOR ANY PURPOSE. THE
AUTHOR WILL ASSUME NO LIABILITY FOR DAMAGES EITHER FROM
THE DIRECT USE OF THIS PRODUCT OR AS A CONSEQUENCE OF
THE USE OF VINO:FILE CELLAR MASTER.
OUR SIMPLE LICENCE CONDITIONS
Purchase of VINO:FILE Cellar Master will license one copy
for use on one computer at any time.
You must treat a copy of VINO:FILE like a book - it may be
used by more than one person and moved from one computer to
another as long as there is no possibility of it being used
at one location while it's being used at another (just like
a book cannot be read by more than one person at a time).
A NOTE ABOUT THIS MANUAL
This manual is included on the VINO:FILE disks. The
content is exactly the same as the printed version that
comes with registered versions of the program. However, the
screen illustrations are removed and other minor formatting
details changed due to the requirements of producing a
plain text version from source material designed to be
typeset.
VINO:FILE Cellar Master
Copyright Mark Christian 1990, 1992
All rights reserved.
---------------------------------------------------------------
Preface Page ii VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
ENQUIRIES, REGISTRATIONS & SUPPORT
For Technical Support and General Enquiries, please contact
the author in one of the following ways (in approximate
order of preference):
. On CompuServe, via the `Bacchus Wine Forum' - GO
WINEFO - or CompuServe Mail to ID [70032,117].
(Please send registrations by mail to the address
below.)
. By Mail to: Mark Christian,
7 Campbell Grove,
East Hawthorn, 3123,
Australia.
or: Mark Christian,
210 Columbus Ave, Suite 220,
San Francisco, CA, 94133,
USA.
. FAX: +61-3-882-0640 (Australia).
If you have suggestions, complaints, or ideas for future
enhancements please feel free to contact us. We welcome
any feedback from users and will do our best to incorporate
all ideas in future versions of VINO:FILE Cellar Master.
Only you, the users, can make VINO:FILE the most complete
and functional cellar management software available from
any source! With your help we will continue to make
VINO:FILE the only wine cellar software that fully meets
the needs of all of its users.
If there is any defect in the VINO:FILE diskettes or
documentation - or if any files appear to be missing or
incomplete - please contact the author. You will find a
list of files later in this manual and also in the file
VINOREAD.ME.
---------------------------------------------------------------
Preface Page iii VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
ASP OMBUDSMAN
This program is produced by a member of the Association of
Shareware Professionals (ASP). ASP wants to make sure that
the shareware principle works for you. If you are unable
to resolve a shareware-related problem with an ASP member
by contacting the member directly, ASP may be able to help.
The ASP Ombudsman can help you resolve a dispute or problem
with an ASP member, but does not provide technical support
for members' products. Please write to the ASP Ombudsman
at 545 Grover Rd., Muskegon, MI 49442-9427 or send a
message via CompuServe Mail to ASP Ombudsman 70007,3536.
The Ombudsman may be contacted by FAX by sending to the ASP
FAX number: (616) 788-2765. In communication with the
Ombudsman please include a telephone number and/or FAX if
available.
---------------------------------------------------------------
Preface Page iv VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
TABLE OF CONTENTS
SECTION I. INTRODUCTION 1
1.1. WHY VINO:FILE ? 1
1.2. SYSTEM REQUIREMENTS 2
1.3. WHAT'S NEW IN VERSION 3 2
SECTION II. GETTING STARTED 5
2.1. INSTALLING VINO:FILE 5
2.2. THE VINO:FILE FILES 5
2.3. STARTING VINO:FILE WITH THE SAMPLE DATABASE 5
2.4. SETTING YOUR CONFIGURATION 6
2.5. A GUIDED TOUR OF THE MAIN FEATURES 7
2.5.1. SEARCHING FOR WINES 7
2.5.2. USING WINE LISTS 10
2.5.3. DISPLAYING BOTTLE LISTS 12
2.5.4. CHANGING A BOTTLE RECORD 13
2.5.5. DRINKING A BOTTLE OF WINE 14
2.5.6. UN-DRINKING BOTTLE RECORDS 15
2.5.7. ADDING WINES TO THE DATABASE 15
2.5.8. CHANGING A WINE RECORD 19
2.5.9. SAVING & CHANGING DATABASE FILES 19
2.5.10. ADDING, RESTORING AND RE-SORTING 20
2.5.11. SUMMARY SCREENS 21
2.5.12. CHANGE CONFIGURATION 22
2.5.13. PRINTING REPORTS 25
2.5.14. THE CROSS REFERENCE FILE 26
2.5.15. QUITTING VINO:FILE 28
SECTION III. GENERAL INFORMATION 29
3.1. COMMAND LINE PARAMETERS 29
3.2. SYSTEM PLATFORMS 30
3.2.1. MICROSOFT WINDOWS 30
3.2.2. DESQVIEW 31
3.2.3. OS/2 31
3.2.4. ULTRAVISION 32
3.3. MERGING SAMPLE CROSS REFERENCE FILES 32
3.4. SCREEN LAYOUT AND DATA ENTRY 33
3.4.1. USING THE MOUSE 33
3.4.2. STATUS LINE 34
3.4.3. DATA ENTRY PANELS 34
3.4.4. FIELD EDITING COMMANDS 35
3.4.5. MEMO FIELDS 37
3.4.6. SPECIAL FIELDS 39
3.4.7. THE MENU BAR 41
3.4.8. HELP PANELS 41
3.4.9. SCROLLABLE LISTS 42
---------------------------------------------------------------
Table Of Contents Page v VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
SECTION IV. USER REFERENCE 44
4.1. VINO:FILE MENU FUNCTIONS 44
4.1.1. OPEN NEW DATABASE 44
4.1.2. IMPORTING & EXPORTING TEXT FILES 44
4.1.2.1. IMPORT A FILE 45
4.1.2.2. EXPORT A FILE 46
4.1.2.3. TEXT FILE FORMATS 46
4.1.2.4. GENERAL IMPORT FIELD RULES 47
4.1.2.5. IMPORT WINE RECORD FORMAT 48
4.1.2.6. USING CROSS REFERENCE IN IMPORT 50
4.1.2.7. IMPORT BOTTLE RECORD FORMAT 51
4.1.3. SHELL TO DOS 52
4.1.4. ADD TASTING NOTES 52
4.1.5. RESTORE DELETED WINES 53
4.1.6. BROWSE DELETED BOTTLE PANEL 53
4.1.7. SHOW CELLAR STATISTICS 54
4.1.8. MEMORY USAGE SUMMARY 55
4.1.9. OPEN A NEW CROSS REFERENCE 57
4.1.10. PRINT A CROSS REFERENCE REPORT 58
4.1.11. THE VARIETY CROSS REFERENCE LIST 58
4.2. THE VINO:FILE DATABASE STRUCTURE 59
4.2.1. RECORD STRUCTURES 59
4.2.2. DATABASE CAPACITY 60
INDEX 63
---------------------------------------------------------------
Table Of Contents Page vi VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
SECTION I. INTRODUCTION
1.1. WHY VINO:FILE ?
Do you need to keep track of the bottles of wine in your
cellar and have instant access to your tasting notes? Want
to be able to analyze the geographical spread of your
collection, maintain a list of wines to drink or taste
soon, and identify future purchasing needs? Would you like
to locate a particular bottle of wine by bin or box number
- without hunting through the cellar, packing and unpacking
valuable bottles?
The VINO:FILE Cellar Master program is the answer for every
wine lover with access to an IBM PC or compatible.
VINO:FILE was written by a wine collector with a moderate
sized cellar of 60 dozen bottles - so you know that this
program, and future enhancements, will be geared towards
the needs of fellow wine lovers, not the pre-conceived
ideas of a large software publisher.
VINO:FILE's database system is tailored especially for wine
cellar record keeping. It gives you instant access to
information about the bottles of wine in your cellar, and
allows you to file tasting notes for future reference once
you have consumed the wines.
Want to know how many 1985 Cabernet Sauvignons are in your
cellar? VINO:FILE will tell you. Trying to remember
whether you thought the 1974 Chateau Palmer was better than
the 1975? Just look up your notes - with a single query!
Wine records are kept in your computer's memory while
VINO:FILE is running for fast and flexible execution and
then stored in a single disk file between sessions. You
can search wine records using many fields including the
Producer, Variety, Year, Geographical Origin, Peak Drinking
Period, Category, Rating and Cellar Location.
While you work, VINO:FILE uses a Cross Reference file to
keep track of the geographic origins of the wines you file
in the database. This saves you from having to enter that
information more than once. The information in the Cross
Reference file is used so that you need a minimum of typing
to enter new entries to your database. Sample Cross
Reference files for the major wineries in America,
Australia and Europe are provided.
Easy to use menus and lists drive all of VINO:FILE's
functions with full error messages and help panels. The
windowing interface is easy to use for novices and
experienced PC users alike. Full mouse support is
included. Mastering your wine records is just a few
keystrokes away!
---------------------------------------------------------------
Section I. Introduction Page 1 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
For a quick guide to VINO:FILE and a guided tour of its
major features see the next section `Getting Started' -
you'll see how easy to use and powerful VINO:FILE is. When
you begin using the more advanced features, you'll find the
`General Information' and `User Reference' sections have
all the details that you need to get the most from
VINO:FILE Cellar Master.
1.2. SYSTEM REQUIREMENTS
To run VINO:FILE Cellar Master you will need:
. an IBM (or compatible) PC with DOS
. 640 Kb of RAM memory (445,000 bytes free)
. a high density 3.5" or 5.25" floppy disk drive*
* You can install VINO:FILE from low density (DS-DD)
diskettes but the VINO:FILE files are too large to
run from this type of diskette. You can run the
program from a high density (DS-HD) 5.25" or 3.5"
diskette or from a hard disk.
For optimum use of VINO:FILE it is desirable to have:
. a hard disk drive
1.3. WHAT'S NEW IN VERSION 3
VINO:FILE Cellar Master Version 3 is a major update. Users
of Version 2 will be especially interested in these major
new features:
. Full Mouse support is now included. All data
fields, menu items and status line options are Hot
Spots where you can click with your mouse to
perform the appropriate actions.
. VINO:FILE now uses virtual memory paging to allow
Wine Databases and Cross Reference files to be far
bigger than before. If enough RAM is not available
then VINO:FILE can use EMS (Expanded) memory, XMS
(Extended) memory or Disk space to store the data.
. Two User fields and three Rating fields have been
added to the Wine Record. The names of these
fields can be specified by the user. The size of
several other fields has been increased.
---------------------------------------------------------------
Section I. Introduction Page 2 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
. The Help system is much improved and uses a
Hypertext system to allow navigation and browsing
of all help options.
. Automatic support for screen sizes larger than
80x25, such as provided by Ultravision, is now
included.
. You can now sort the Wine List on any combination
of fields for better analysis of your cellar and
customization of printed reports.
. The Cellar Statistics function allows detailed
analysis of your cellar contents using any of the
wine fields for displaying or printing in graphic
and tabular form.
. A new option `Add Tasting Notes' on the Add Menu
allows quicker entry of tasting notes where the
wine tasted was not already in your cellar.
. Alphanumeric data values can now be presented in
Upper, Lower or Mixed cases for greater
readability.
. Turbo Fields allow you to paste in winery names,
varieties, districts, states or countries with a
minimum of typing when entering or changing data.
. Improvements to the Wine List include:
. scrolling horizontally to make other fields
visible;
. a Repeat function to aid in entering new wines
similar to one already there;
. a Zap function to temporarily hide a wine so
that it is not displayed in the list;
. a Re-List function to re-search the wine list.
. On the Bottle List you can now use the F3 and F4
keys to skip to the bottle list of the next or
previous wine in the wine list.
---------------------------------------------------------------
Section I. Introduction Page 3 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
. Several improvements have been made to the Wine
Search panel:
. You can enter *99 and #99 in Year Ready and
Drink By search fields to find wines that are
ready or not ready in a particular year instead
of in the current year.
. You can enter `+' or `-' in all search fields
to search on `any value' and `blank'
respectively.
. Instead of just a default bottle search value
you can now save ALL of the fields on the Wine
Search panel between sessions. Select the `Save
Search Record' option on Change Configuration.
---------------------------------------------------------------
Section I. Introduction Page 4 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
SECTION II. GETTING STARTED
2.1. INSTALLING VINO:FILE
VINO:FILE comes with an automated installation program
called INSTALL. To install the VINO:FILE program files
from a floppy disk (assuming the floppy is in drive `A'):
. place the diskette in your floppy disk drive
. run the install procedure by typing `A:INSTALL'
You will be able to choose where to put the program files
on your system. If you have a hard disk drive we highly
recommend that you install VINO:FILE there.
2.2. THE VINO:FILE FILES
The INSTALL program places the following files on your
system:
AUSSIE.XRF Sample Cross Reference - Australia
EUROPE.XRF Sample Cross Reference - Europe
SAMPLE.DBA Sample Wine Database
USA.XRF Sample Cross Reference - USA
VF.EXE VINO:FILE Program File
VF.HLP VINO:FILE Help File
VF.ICO Windows 3.0 Icon
VF.OVR VINO:FILE Overlay File
VF.PIF Windows 3.0 PIF File
VINOREAD.ME Documentation Updates
WINE.XRF Sample Cross Reference File
For information on VINO:FILE that could not be included in
this manual please print or display the file `VINOREAD.ME'.
2.3. STARTING VINO:FILE WITH THE SAMPLE DATABASE
VINO:FILE comes with a sample wine database and cross
reference file so that you can get a feel for the program
as soon as you have installed it.
The sample wine database (SAMPLE.DBA) contains a variety of
wine records and shows how to enter the wines of various
countries into VINO:FILE with typical contents for the
various data fields.
---------------------------------------------------------------
Section II. Getting Started Page 5 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
The sample cross reference (WINE.XRF) is a starter set of
cross reference entries for some of the world's most common
wine producing areas. The cross reference file helps you
avoid typing in the geographic locations for every
different wine that you enter into the database.
To start VINO:FILE and load up the samples change to the
directory on your hard disk where you installed VINO:FILE
and type:
VF SAMPLE
If you want to start your own database you can load
VINO:FILE by just typing `VF'.
2.4. SETTING YOUR CONFIGURATION
VINO:FILE Cellar Master uses a configuration file
(WINEPARM.CFG) to keep configuration settings from session
to session. One of these settings is the color set used by
the program.
If the default colors are difficult to read on your
computer's screen you should use the command line options
`/L' or `/M' to select an alternative video mode and then
change your configuration settings to ensure that this
setting is active every time you start VINO:FILE.
If you start VINO:FILE by typing `VF /L' on the command
line, an alternative color set is used which should be more
readable on some laptops or other computer displays which
map colors to shades of gray. To use a monochrome color
set, start VINO:FILE by typing `VF /M' on the command
line. Try both of these to determine which is best for
your computer.
Now bring up the `Summary' menu by pressing Alt-S (or press
F10, use the right arrow to move the cursor to `Summary'
and then press Enter). Choose `Change Configuration' by
pressing the down arrow until that choice is highlighted
and then pressing Enter. This will display the
configuration panel.
The `Video Mode' is the option that controls the color set
used. Set this field to be `L' or `M' whichever you have
decided is best for you. A `C' in this field denotes the
default color set. Then press Ctrl-Enter (hold down the
Ctrl key while pressing Enter) to accept the changes. When
you change the `Video Mode' on this panel you must quit
VINO:FILE by pressing Alt-Q or Esc, and then restart the
program before the change will take effect.
The other settings on this panel are described in the
Change Configuration section beginning on page 22.
---------------------------------------------------------------
Section II. Getting Started Page 6 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
2.5. A GUIDED TOUR OF THE MAIN FEATURES
To introduce new users to VINO:FILE Cellar Master, this
section provides a step by step guide to the major
functions of the program. Users who are upgrading from
previous versions or who are already familiar with the main
features of VINO:FILE may skip this section.
To follow this `guided tour' you should load the SAMPLE
database that is distributed with VINO:FILE. Start up the
program with the following line command:
VF SAMPLE
After the database is loaded you will see the `Wine Search'
panel.
All the panels in VINO:FILE have the same basic structure.
Across the top of the screen is the `Menu Bar' which you
can use to access various utility functions. Across the
bottom of the screen is the `Status Line' which shows the
main key functions for each screen and also displays error
messages. You can get help from any panel by pressing
`F1'.
To exit from a panel without saving any changes you press
Esc (the escape key). To exit and accept all field entries
or changes press Ctrl-Enter (hold down the Ctrl key while
pressing Enter).
If you have a mouse you will see the mouse cursor - a white
diamond on a red background - which you can move around the
screens. Use the left button to select fields, actions and
menu items. Clicking on the right button of the mouse is
equivalent to pressing Esc and will exit from the current
panel without saving any changes.
Note: VINO:FILE supports screens larger than the standard
80x25 screen size. If you have a screen size utility such
as Ultravision the screens you see are slightly different
to the illustrations in this manual.
2.5.1. SEARCHING FOR WINES
The Wine Search Panel is displayed when you start up
VINO:FILE. Check now that you have loaded the sample
database - on the left side of the title box you should see
`- Database -' and underneath that the name of the wine
database `SAMPLE'. On the right hand side you should see
`- XRef -' and `WINE' which is the name of the sample cross
reference.
---------------------------------------------------------------
Section II. Getting Started Page 7 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
On this panel you enter search arguments to determine which
of the records in the database will be listed. By pressing
Enter without any search criteria you can display a list of
all wines in the database. This will include all wines
that have ever been in the cellar. Press Enter now.
To return to the Wine Search panel, press Esc.
All the search criteria on this panel are AND-ed together
to restrict the list of wines to be displayed. In this way
you can construct very quickly a simple, or complicated,
search for a particular wine or group of wines.
Type the name `PINE RIDGE' in the `PRODUCER' field. Press
Enter to perform the search after entering the name - you
should now see a list of wines from the Pine Ridge winery
only. Press Esc again.
Some of the fields on the Wine Search panel are `Turbo
Fields'. You might have noticed when typing `PINE RIDGE'
before that some winery names were displayed at the bottom
right part of the screen.
When you start typing a Producer name, VINO:FILE will
search the Cross Reference to see if it recognizes what you
are typing. So, when you press the `P' key, the first
producer in the Cross Reference that begins with `P' will
appear - Pecota. When you press `I', that changes to
`Pichon Lalande', and when you press the `N' key it finds
`Pine Ridge'. Now press Enter to paste in that name - only
3 keystrokes instead of 10!
You can also use wild card searches - type `P*' in the
Producer field. Now when you press enter you will see a
list of all the wineries that begin with the letter `P'.
Press Esc again.
Instead of wild cards that will match anything - including
blank values - you can search for `any value' by entering
`+' in any of the fields. To search for `no value' you can
enter `-' in any field.
Remove the producer name by pressing the space bar - any
character typed in the first position of a field will erase
the entire field. If you want to change one or more
characters in the field without erasing it you must first
use the right arrow to move the cursor away from the first
position.
---------------------------------------------------------------
Section II. Getting Started Page 8 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
Use TAB and the down arrow to move over to the District
field. Type `NAPA VALLEY' (this is another Turbo Field).
Use Shift-TAB to move back to the Variety field. Type
`Cabernet Sauvignon' (and this is another Turbo Field - you
could have used only 2 keystrokes for both of these
selections!). Now when you press enter you will see a list
of all the Cabernet Sauvignon wines from the Napa Valley.
Press Esc again.
Press F3 to clear all of the fields on the Wine Search
panel.
Another shortcut - `Two-Digit Years' is available in the
Year fields (including Year Ready and Drink By). You can
type `1985' in the Year field to find all the wines from
that vintage - but why waste your time typing `19' every
time? Try just typing `85' - VINO:FILE will fill in the
rest for you! If you type `00' in the Drink By field
VINO:FILE is clever enough to know that you want the year
2000 rather than the year 1900!
Use the Down Arrow key to move down to the Bottles field.
Change the value from `0' to `1'. Now when you press
Enter, the list of wines will only contain wines of which
there are at least one bottle currently in the cellar. To
display the wines of which there is exactly one bottle in
the cellar enter `=' in the `Bottles Search Type' field.
You will also see Search Type fields for the Year field and
the Ratings fields. To toggle through the possible values
for any of the Search Type fields use the space bar or the
`+' and `-' keys.
Finally, you can use the `Year Ready' and `Drink By' search
fields to identify those wines in your cellar that are in
their optimal drinking period.
First clear all fields by pressing F3 and then enter `89'
in the Year Ready field. Press Enter to display a list of
all wines that became ready to drink in 1989. Clear the
Year Ready field and enter `95' in the Drink By field.
Press Enter to display a list of the wines to drink before
1995.
There are two special searches in the Year Ready and Drink
By fields - `*' which means `ready' and `#' which means
`not ready'.
In the Year Ready field, `*' will display all wines that
are ready to drink in the current year or earlier - that
is, all wines now ready to drink. The `#' character will
list wines that are not yet ready to drink.
---------------------------------------------------------------
Section II. Getting Started Page 9 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
In the Drink By field, `*' will display all wines to drink
in the current year or later. The `#' character will list
wines that have passed their Drink By date - that is, wines
that may be `over the hill'.
To list all wines that are currently in their optimum
drinking period enter `*' in both the Year Ready and Drink
By search fields and press Enter. This will display all
wines that have passed their Year Ready date and have NOT
passed their Drink By date - perfect wines for current
drinking!
If you want to find wines that will be ready next year, or
any other year, you can add a year to these special values.
Try entering `*96' in both Year Ready and Drink By for a
list of wines that will be at their best in 1996.
For information about other fields, and VINO:FILE's field
editing commands, press `F1' to display the Help Screens
for this panel. When you have finished experimenting with
the various searches, clear all the fields, set `Bottles'
to 0, and press Enter to search. The next section uses the
resulting list of wines to explain the options available on
the wine list.
2.5.2. USING WINE LISTS
The wine list is a scrollable list of wines from the
database. The following fields are displayed for each
wine:
. Producer The name of the winery or shipper of the
wine;
. Other Info Any other distinguishing information.
The vineyard name, a bin number, a
`Reserve' wine etc;
. Variety The grape variety (blank if the wine is
not a varietal, such as many European
wines);
. Year The vintage year, which may be blank (or
`NV') for non-vintage wines;
. Number The number of bottles of this wine in
your cellar. A `0' shows that you have
consumed all of these wines.
---------------------------------------------------------------
Section II. Getting Started Page 10 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
The highlight bar and arrow indicator on the left hand side
of the list show the current wine record - starting at the
first wine in the list. You can move the indicator up and
down the list using the Up and Down Arrow keys or by
clicking on the arrow symbols at the top or bottom of the
scroll bar if you have a mouse installed.
Use the PgUp and PgDn keys to scroll the list one page at a
time, or you can click on the PGUP or PGDN symbols on the
bottom right part of the screen. The Home key moves the
indicator to the top of the list, and the End key to the
last wine in the list.
With your mouse you can click on the main part of the
scroll bar at the right side of the list. This will select
the corresponding record - that is, clicking three-quarters
of the way down the scroll bar will scroll to the wine
three-quarters of the way through the list.
Pressing Enter will select the current entry.
You can also scroll the Wine List horizontally to show
other fields in each wine record. Press the Right Arrow
(or F4) to scroll to the right, the Left Arrow (or F3) to
scroll left or click on the symbols at the bottom left part
of the screen. Note that the Producer and Number fields
always remain on screen while the other fields between them
change.
The other Wine Record fields that can be displayed by
scrolling are: Year Ready, Drink By, Flag, Category,
Ratings, User 1 and User 2.
The actions that you can perform on each wine are listed on
the status line at the bottom of the screen. Pressing the
letter indicated or clicking on that part of the status
line performs the action on the current wine:
. A Add more bottles of this wine;
. C Change one or more of the data fields for this
wine;
. D Delete the wine record (and all of its
bottles);
. F Find - searches for a particular producer and
scrolls to that position. The search name is
displayed at the bottom left corner of the
screen - press Enter when you have found the
one that you want;
. R Repeat - add a new wine to the database
starting with all fields the same as the
current wine;
---------------------------------------------------------------
Section II. Getting Started Page 11 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
. S Select this wine and display the list of
bottles (Enter also performs this action);
. Z Zap - remove this wine from the displayed
list. This only affects the display - the wine
is not deleted from the database. You can
reset this by pressing F2 to re-apply all the
current search criteria.
Try out each of these. Press F1 for Help if you are in
doubt at any time.
Now we'll look at a bottle list - position the arrow
indicator to the wine `BEAULIEU VINEYARDS, RUTHERFORD,
CABERNET SAUVIGNON, 1985' and press the `S' or Enter key to
select the bottle list for that wine.
2.5.3. DISPLAYING BOTTLE LISTS
The bottle list is a scrollable list that looks similar to
the wine list. This screen, however, shows all the bottle
records for one particular wine. The main information
about the wine is in the top area of the screen - the wine
you are looking at now should be `BEAULIEU VINEYARDS,
RUTHERFORD, CABERNET SAUVIGNON, 1985'.
In the bottle list part of the screen the following fields
appear for each record. Note that each record represents
one or more identical bottles.
. Number (#) The number of bottles that this record
represents;
. Size The size (in ml) of each bottle;
. Bought The date when these bottles were
purchased;
. Cost The purchase price of each bottle;
. Origin Where the bottles were bought;
. Location The Cellar Location where these bottles
can be found;
. Drank The date when these bottles were
consumed (if applicable);
. Points Your point rating for wines that have
been consumed.
---------------------------------------------------------------
Section II. Getting Started Page 12 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
The key fields for a bottle record are Date Consumed,
Purchase Date, Size and Location - and each record must
have a unique key. Therefore any bottles with the same
values for these four fields will be combined into a single
record. VINO:FILE will look after splitting and combining
records automatically throughout the life of the bottles of
wine.
The highlight bar and arrow indicator show the current
bottle record. You can scroll the bottle list in the same
way as the wine list above.
As a short cut, the F4 key (or right arrow) will skip to
the next wine in the wine list and the F3 key (or left
arrow) to the previous wine.
The actions that you can perform on each bottle record are
listed on the status line at the bottom of the screen.
Pressing the letter indicated or clicking on that part of
the status line performs the action:
. S or C Change data fields for one or more of these
bottles;
. D Drink one or more of these bottles of wine;
. L Delete this bottle record;
. U Un-Drink bottles that are incorrectly marked
as consumed.
Pressing the `F2' key or clicking on the part of the screen
where the Comments data is displayed lets you browse the
full Wine Comments field.
Try out each of these options. Some further notes are
provided on the following pages. Press F1 for Help if you
are in doubt at any time.
2.5.4. CHANGING A BOTTLE RECORD
There are a few tricks when changing the fields of a bottle
record:
. If the bottles in this record have been consumed
then the Date Consumed, Occasion, Tasting Notes and
Points fields are displayed and can be changed. If
the bottles are still in the cellar then these
fields are not displayed.
---------------------------------------------------------------
Section II. Getting Started Page 13 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
. Each record can represent more than one bottle of
wine. So the first question you must answer is do
you want to `Change All Bottles?'. The default is
`Y' - change the fields for all bottles that this
record represents - changing the `Number' field
will change the number of bottles represented by
the record.
. If you set `Change All Bottles' to `N' then you are
splitting this record into two records. Set the
`Number To Change' field to the number of bottles
that will take the changed values, and the
remaining bottles will keep the old values. When
you do this the new bottles must have a new unique
key - therefore you MUST change either the Date
Consumed, Date Purchased, Size or Location fields.
You would use this type of change to move some of
the bottles to a new location, for example.
. The VALUE field defaults to the same as the COST
field when you add bottles to the database. If you
feel that your wines are appreciating (or
depreciating?) you can change their values on this
panel.
. VINO:FILE calculates the Total Cost and Total Value
fields automatically whenever you change the Cost,
Value or Number fields.
2.5.5. DRINKING A BOTTLE OF WINE
Updating the VINO:FILE record after you drink a bottle of
wine is easy:
. On the Bottle List, select a bottle still in the
cellar and press the `D' key. Check that the
existing fields are correct - that you are drinking
the correct bottle - and, if not, press Esc to
cancel;
. Enter the number of bottles that you drank at this
sitting - if you had two or more of these bottles
and the tasting notes are substantially the same,
then you need only enter them once;
. Enter the drink date, occasion (restaurant name,
food served, guests' names etc), tasting notes and
rating (on any scale - with a maximum value of
100.0);
. All fields other than the Number to Drink and Date
Consumed are optional.
---------------------------------------------------------------
Section II. Getting Started Page 14 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
2.5.6. UN-DRINKING BOTTLE RECORDS
If you mistakenly mark a bottle as consumed and later
discover that it is still in the cellar, the Un-Drink
Bottle function will quickly repair the damage.
. On the Bottle List, select a bottle which has been
consumed and press the `U' key;
. Check the warning screen to make sure the correct
bottle was selected;
. The drink date, occasion, tasting notes and points
rating will all be cleared;
. Enter the number of bottles to `Un-Drink', their
Location and Value per bottle. All fields other
than the Number to Un-Drink are optional.
2.5.7. ADDING WINES TO THE DATABASE
To add new wines to the database, you need to use the Menu
Bar. The Menu Bar is the line across the top of the screen
that looks like:
Files Add Summary Print XRef Quit
You can access the Menu Bar from the `Wine Search', `Wine
List' and `Bottle List' screens. Access it by pressing the
F10 key and then using the right and left arrow keys to
move to the appropriate option on the menu. As a shortcut
you can press the Alt key and the first letter of the
option that you want. To Add Wines you can press Alt-A.
Do that now.
We want the first choice on the Add Menu - `Add Wines' - so
make sure that option is highlighted and press Enter to
select it.
The first four fields you enter to add a wine to the
database are the four key fields for a wine record. These
four fields uniquely identify every wine and you may need
to take care entering the `Other Info' field to ensure that
the wines remain unique. This field will normally contain
a bin number or `reserve' notation (for New World wine), a
vineyard name or appellation (for European wines).
Let's add a `Robert Mondavi, Private Reserve, Cabernet
Sauvignon, 1985':
PRODUCER ==> ROBERT MONDAVI
OTHER INFO ==> PRIVATE RESERVE
VARIETY ==> CABERNET SAUVIGNON
YEAR ==> 1985
Don't forget that you can use the Turbo Fields and the Two-
Digit Year features to minimize your typing when filling in
these details.
---------------------------------------------------------------
Section II. Getting Started Page 15 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
You need to enter the `Private Reserve' in the `Other Info'
field to distinguish this wine from the normal non-reserve
Mondavi Cabernet which is a totally different wine.
If, after you enter these fields, VINO:FILE finds that this
wine is already in the database it will allow you to go
straight to the `Add Bottles' screen - or let you change
one of the key fields so that the new wine is unique.
When you press Enter after typing the `Other Info' you will
notice that the District, State and Country fields are
filled in automatically for you - this is the VINO:FILE
Cross Reference file at work. We know that you've got
better things to do than type in `NAPA VALLEY, CALIFORNIA,
USA' every time you enter a wine from that district into
the database.
So, we've included a sample cross reference file that knows
the location of many of California's best known wineries
and several others from around the world. If VINO:FILE's
Cross Reference does not know which District the winery is
in, chances are it does know that District once you type it
- so it will then enter the State and the Country for you.
What's more, whenever you enter a winery, a district, a
state or even a country that is not already in the Cross
Reference file - VINO:FILE will add it to your Cross
Reference for future use.
VINO:FILE has other sample Cross Reference files that
include almost all the wines in California and Australia
and many of the better known wines of France, Italy and the
rest of Europe - see the `Merging Sample Cross Reference
Files' section beginning on page 32 for details of how to
use these extra files.
When you enter the Variety the Category is also filled in
for you from the Cross Reference file.
Once the geographical information is complete, there are
nine further fields. These fields are completely optional,
and the following might be applicable for the Mondavi
Reserve that we used as our example above:
User 1 ==>
User 2 ==>
Year Ready ==> 1990 Drink By ==> 1999 Flag ==>
Rating 1 ==> 0.0 Rating 2 ==> 0.0 Rating 3 ==> 0.0
Comments ==> Exciting. More evolved than the 1984 but
promises more eventual subtlety. Already
approachable, but its fascination should
increase. (JR)
---------------------------------------------------------------
Section II. Getting Started Page 16 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
Use these fields as follows:
. CATEGORY Two free-form characters that allow
searching on different styles of wine.
We suggest the following abbreviations
although you can modify these and add
your own abbreviations for other styles:
DR Dry Red
DW Dry White
SW Sweet White
MC Methode Champenoise (Champagne)
FO Fortified wines (Ports and
Sherries).
. USER 1, USER 2 As their names suggest, you can use
the User 1 and User 2 fields for
anything you like. If there's
information you would like to keep that
VINO:FILE does not provide a field for
you can use these. You can even change
the field names to match the contents -
see Change Configuration for details.
. YEAR READY, DRINK BY
The approximate years between which you
aim to drink the bottles of this wine.
The values above are from Jancis
Robinson's `Vintage Timecharts' for the
1985 Mondavi Reserve Cabernet Sauvignon.
. FLAG You can use this single character any
way you like to give you an extra search
field. You might want to use `Q' or `*'
to denote wines that are in your
drinking / tasting queue, or `$' to
indicate a good value wine.
. RATING 1, RATING 2, RATING 3
The Rating fields can be your own, or
from industry guides such as Robert
Parker, The Wine Spectator, or Decanter.
Like the User fields you can change the
field names for all of these to match
their contents.
. COMMENTS A text memo field. Enter as many lines
of comments on this wine as you like.
You could use this field to enter a
winemaker's comments, a Parker review,
or any other information that might help
you keep an accurate record of this
wine. Again, the above comments are
courtesy of Jancis Robinson.
---------------------------------------------------------------
Section II. Getting Started Page 17 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
Of course, you can come back and change any of these values
later using the `Change Wine' screen so if you don't have
the information at hand just leave those fields blank or
accept the default values.
Once you've entered the wine record details you need to
enter the details of the bottles you have bought. Press
Ctrl_Enter on the Add Wine screen to display the `Add
Bottles' screen.
Now enter the following fields:
. NUMBER OF BOTTLES The number of bottles of this wine
that you purchased;
. DATE OF PURCHASE The date you bought them (defaults
to current date). You can blank
out the field if you do not know
when you acquired these bottles;
. COST PER BOTTLE The price you paid - per bottle
(the total cost will be calculated
for you);
. SIZE OF BOTTLE The size in ml (millilitres) per
bottle - usually 750 ml;
. ORIGIN Free-form characters indicating
where you purchased these bottles
of wine;
. LOCATION The cellar location (bin number,
box number, room number etc) where
these wines are kept.
Again, you can come back and change any of these values
later using the `Change Bottle' screen so if you don't have
the information at hand just leave those fields blank or
accept the default values.
After you enter these fields, the `Add Wine' screen will be
displayed again for adding more wines.
For all subsequent wines you can recall the field values
for the last wine added by pressing F2 - this will make it
quicker and easier to add several wines that have some
values the same.
You can use the F2 recall key in both the `Add Wine' or
`Add Bottles' screen.
---------------------------------------------------------------
Section II. Getting Started Page 18 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
2.5.8. CHANGING A WINE RECORD
To change a wine record, highlight it on the Wine List and
press `C'.
You can edit all fields on this panel. The usage of each
of the fields is described above in the `Adding Wines to
the Database' section.
2.5.9. SAVING & CHANGING DATABASE FILES
You can keep more than one wine database on your hard disk.
At the moment you have the database `SAMPLE.DBA' loaded.
So that you can make changes without permanently altering
the sample database you should now save the database under
a new name.
Return to the `Wine Search' panel and bring up the Files
Menu by pressing Alt-F, or F10 and then Enter.
Move to the third choice `Save Database As ...' using the
down arrow and then press Enter or press the `A' key. You
can now enter a new name. Type in any name - up to 8
characters in the normal DOS way. The extension .DBA will
be added by VINO:FILE and the database saved to disk.
VINO:FILE will check to see that your database name is
valid and that it doesn't already exist.
To save the database without changing the name you can use
the second option on the Files Menu - `Save Database'.
If you like, you can reload the sample database. Choose
the first item on the Files Menu - `Open New Database'.
Leave the `Load Option' as `NEW' and type `SAMPLE' for the
new name. Alternately you can leave the new name blank and
choose a database from the directory list.
There are two ways you can load a database. Mostly you
will load it as `NEW' - this will clear the database
currently in memory and load the new one in its place.
Sometimes you might want to `MERGE' two databases together,
where you add the wines and bottles from the new database
to the one already in memory - discarding duplicates.
The other options on the Files menu are detailed in the
User Reference section. Briefly:
. Clear Database
Erase the database in memory and start
afresh.
---------------------------------------------------------------
Section II. Getting Started Page 19 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
. Import File
Read a text file and create a database
from it. The text file format must be
exact - see the `Importing and Exporting
Text Files' section on page 44 for
details.
. Export File
Write the database to a text file - the
format is the same as for Import files.
. Shell to DOS
Temporarily exit VINO:FILE so that you
can run a program from the DOS prompt.
2.5.10. ADDING, RESTORING AND RE-SORTING
We've already used the Add Menu to add new wines to the
database. There are several other options on this menu.
`Add Tasting Notes' provides a quick way of entering
tasting notes for bottles of wine that did not come from
your cellar. You can enter the wine details and bottle
details - including tasting notes in one step. Details are
in the User's Reference section, beginning on page 52.
`Restore Deleted Wines' ensures that you can recover
deleted wine or bottle records if you have erased them by
mistake. Details are in the User's Reference section,
beginning on page 53.
`Sort Wine List' allows you to resort the wine list on any
combination of wine record fields. Normally the wine list
is in key sequence - Producer is the primary key with Other
Info, Variety and Year as secondary keys. You can change
the sort order by specifying up to 12 sort fields.
To sort the wine list geographically, for example, use the
space bar or `+' and ` -' keys to change the sort fields as
shown below.
Now press Ctrl_Enter to resort the wine list.
If you list the wines you will see all the Australian wines
at the top followed by France, Germany, Italy and the USA.
Within each country the wines are sorted by State and those
in the same state are sorted by District.
To return to the normal sort order select `Sort Wine List'
again, press the F2 key to reset to the default sort fields
and then Ctrl_Enter.
To reset any single sort field press F3 when the cursor is
on it to change it to ` - None - `.
---------------------------------------------------------------
Section II. Getting Started Page 20 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
Sorting the wine list is very helpful when preparing
printed reports as the wines are printed in the same order
as the wine list is sorted.
2.5.11. SUMMARY SCREENS
To display information about the current database bring up
the Summary Menu by pressing Alt-S.
The Database Summary shows statistical information:
. The number of wine and bottle records (and actual
bottles);
. The number of memo fields and text records (each
text record is a line of text in the Comments,
Occasion and Taste memo fields);
. The total cost of all wines in the database (you're
allowed to close your eyes and not look at this
one!);
. The number of wines and bottles that are currently
in the cellar (that is, not yet consumed) and the
cost and total value of those wines;
. The Date of Valuation. If you re-value your cellar
on a regular basis (for insurance purposes, for
example) you can record and change the Valuation
Date by pressing F2 on this screen.
The `List Summary' shows similar information but is
restricted to the CURRENTLY SELECTED LIST of wines only -
determined by the criteria that you last entered on the
Wine Search screen.
`Show Cellar Statistics' allows you to display and print a
wide range of statistical reports about your cellar.
Details are in the User Reference section beginning on page
54.
`Memory Usage' shows how VINO:FILE is storing the Database
and Cross Reference information while the program is
running. This information is mostly for debugging purposes
but you will notice that the program makes use of Expanded
(EMS) and / or Extended (XMS) memory if you have those
types available in your system.
`About VINO:FILE' displays information about the program,
the version number, copyright information, where to get
support.
---------------------------------------------------------------
Section II. Getting Started Page 21 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
2.5.12. CHANGE CONFIGURATION
VINO:FILE stores its start-up options in a configuration
file (WINEPARM.CFG). You can change these options by
selecting `Change Configuration' on the `Summary Menu'.
Depending on your computer system, you may like to change
some of these options now:
. Auto Currency Format If set to `Y', which is the
default, the information DOS has
about your country will be used to
format all currency values
throughout the program.
If you are living outside North
America you will need to have a
`COUNTRY=xxx' command in your
CONFIG.SYS file - details are in
your DOS manual.
. Currency Symbol This field is displayed ONLY if
Auto Currency Format is `N'.
Defaults to `$'. If you are in
another country you can change
this to the appropriate symbol for
your currency. Up to three
characters are allowed.
. Decimal Places This field is displayed ONLY if
Auto Currency Format is `N'.
Defaults to `2' which means that
all currency values will have 2
decimal places - for example,
5.99. If this is not appropriate
for your country you can choose
any number from 0 to 4.
. Date Format The display of date fields
defaults to the format that DOS
uses in directory displays (mm-dd-
yy in North America). To choose a
different format toggle through
the possible values using the `+'
and `-' keys.
. Max String Length The size of the memo field edit
buffer. Defaults to 1750
characters, you can increase it if
you need more room for editing -
to a maximum of 32767 characters.
. Initial Database The name of the database to be
loaded when VINO:FILE starts.
---------------------------------------------------------------
Section II. Getting Started Page 22 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
. Initial XRef File The name of the Cross Reference
file to be loaded when VINO:FILE
starts.
. Video Mode The color set to use. If you have
a color monitor you should leave
this set to `C'. If your monitor
does not display color then you
can set the video mode to `L' - an
alternative color set that
displays better on some laptop
gray-scale screens - or `M' for
monochrome displays.
. Use Mouse ? If you have a mouse but, for some
reason, do not want VINO:FILE to
use it set this to `N'.
. Disable Brightness VINO:FILE uses special video
functions to display bright
background colors. Most systems
will handle this without any
problems and this option should be
left as `N'. If you get strange
blinking you should disable the
feature by setting this to `Y'.
. Screen Size VINO:FILE will adjust to systems
that can display more than the
usual 80 columns and 25 lines.
On EGA or VGA systems there is a
special 43/50 line mode and
utilities such as Ultravision
allow even more choices. You can
force VINO:FILE to run in `25
Line' or `43/50 Line' modes.
When set to `Default' VINO:FILE
will run in the same screen mode
that was active when it started.
. Pop Menus ? Determines whether to pop menus
all the way back to where you were
or step back one level at a time
when a menu function is complete.
. String Fields VINO:FILE can format all string
fields to Upper, Lower or Mixed
case. If you prefer, set this to
`Anything' to display fields
exactly as you enter them. For
mixed case format rules see page
40.
---------------------------------------------------------------
Section II. Getting Started Page 23 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
. User FieldName 1, User FieldName 2
You can change the prompts that
will be displayed on all VINO:FILE
panels for the two User fields in
the Wine Record to match the use
that you have chosen for each
field.
. Rating FieldName 1, Rating FieldName 2, Rating
FieldName 3
You can change the prompts that
will be displayed for the three
Rating fields in the Wine Record
to match the use that you have
chosen for each field.
. Save Search Record If set to `Y', all the search
criteria on the Wine Search screen
are saved between VINO:FILE
sessions.
. Temporary Files Directory a directory on your hard disk
where VINO:FILE can put temporary
files. It can be the same as the
directory where you have installed
VINO:FILE or any other directory.
If you have a RAM disk you could
use that.
. Initial Data Directory a directory on your hard disk
- or floppy diskette - where
VINO:FILE can find and store your
databases and Cross Reference
files.
. Default Print Header The heading text that you want
on your printed reports.
Most field changes will take effect immediately except:
. Initial Database, Initial XRef and Initial Data
Directory are only relevant at program start up;
. Video Mode, Screen Size and Use Mouse. You must
quit VINO:FILE and restart to ensure full use of
the new options.
---------------------------------------------------------------
Section II. Getting Started Page 24 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
2.5.13. PRINTING REPORTS
If you have a printer you can produce printed reports by
selecting the `Print Menu'. The first thing to do is
ensure that your printer is set up correctly.
Choose the third option - `Printer Setup'. You can use
five printer types for formatting: EPSON printers, the
Hewlett Packard LaserJet (HPLJ) series, the HPLJ+ printer
(use this if your LaserJet does not have a 12 point font),
the IBM Proprinter line and generic ASCII printers.
Many others can emulate one of these printers - so even if
you don't have those particular brands you may still be
able to get formatted printouts.
If not, choose `NONE'. You can still print reports but
won't get any bold face or different point sizes. Choose
`NONE' if you want to output standard ASCII disk files for
your reports.
VINO:FILE also needs to know your printer port . VINO:FILE
can print to a parallel port (LPT1 - 4) or to a disk file
but not to a serial (COM) port.
If your printer is attached serially you can still print
but will have to use the DOS MODE command to re-direct the
output from serial to parallel - see your DOS manual for
details on the MODE command.
If you select `FILE', VINO:FILE will prompt you for a file
name for each report that you print.
Once you have set your printer you can print either the
entire database or just the wines that are currently
displayed on the `Wine List' screen. The printout options
are the same.
Print Wine Details can be:
. NO Print only the name of the wine (Producer,
Other Info, Variety, Year), the number of
bottles and their locations.
. YES Print all wine record fields.
Print Bottles can be:
. NO No bottle details are printed at all.
. YES Print the bottle record fields (Date Bought,
Date Consumed, Origin, Cost etc) but not the
Occasion and Tasting Notes.
---------------------------------------------------------------
Section II. Getting Started Page 25 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
. FULL Print all fields, including the Occasion and
Tasting Notes.
Heading Text:
. A heading for each page of the report.
You can cancel a report that has started printing by
pressing Ctrl_C - that is, hold down the Ctrl key while
pressing the C key. You can then confirm that you want to
cancel the report. If you answer `Y' the report will be
cancelled immediately. Press any other key to resume the
printout. Note that some printers (and software print
spoolers) will buffer data before printing it, so the
printer may not stop printing immediately.
Reports are printed in the same order as the wine list - if
you want to have the wines printed out in a different order
just re-sort the list by choosing `Sort Wine List' on the
Add Menu.
You can also print out Cellar Statistics and Cross
Reference reports. Details are on pages 54 and 58
respectively.
2.5.14. THE CROSS REFERENCE FILE
VINO:FILE uses a Cross Reference file to record the
geographic location of all the wineries / vineyards or
shippers that you have ever entered into your database.
That way, if you enter that winery name again you will not
have to re-enter the District, State or Country. This
information is also used for the Turbo Field facilities.
The Cross Reference also keeps track of Varieties that you
have entered and the Category that is usually associated
with that variety.
You can display and modify the Cross Reference file using
the `XRef Menu' options. They are:
. List XRef List all Cross Reference records.
This produces a scrollable list
where you can change, delete or
add entries;
. Open New XRef Load a different Cross Reference;
. Save XRef Save the Cross Reference file to
disk;
. Print XRef Print Cross Reference Reports;
---------------------------------------------------------------
Section II. Getting Started Page 26 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
. Variety List List all Variety records. This
produces a scrollable list of
varieties and you can choose to
change, delete or add entries.
Choose `List XRef' now and you will see the XRef List
sorted by the `Producer' field. This shows the District
for each Producer / Other Info combination.
To see and/or change the State and Country for an entry,
position the indicator using the Up and Down Arrows and
press `S', `C' or Enter. You can also press `A' to add a
new Cross Reference entry, `D' to delete an entry or `F'
to find a particular entry in the list.
Each Producer Cross Reference file entry contains:
. Producer the winery, producer or shipper;
. Other Info a specific notation, or vineyard name.
Many wineries have vineyards in
different districts and you can have an
entry for each. If a winery produces all
its wine in one district you should set
this field to `*' which will match any
value;
. District the District where the grapes
originated. This can be left blank for
wines which obtain their fruit from
multiple areas;
. State the State where that District is
located. This can be left blank for
wines which obtain their fruit from
multiple states;
. Country the Country of origin. Cannot be left
blank.
You can also display the Cross Reference List sorted by
District. Press F2 to toggle the sort order from `By
Producer' to `By District'.
To change a district entry, press `C' after positioning the
record pointer. This will change the details for all
companies that are in this district.
You can use the `By District' display to ensure that your
Cross Reference file is as accurate as possible. If you
have entered `Sonoma' for some companies and `Sonoma
County' for others, you can set all the entries to one
value by changing the misspelled or incorrect entry here.
---------------------------------------------------------------
Section II. Getting Started Page 27 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
To see the list of companies for a particular District,
position the indicator using the Up and Down Arrow keys and
press `S' or Enter. Press F2 again to resort the list by
Country and State.
The sub-list of companies is also scrollable and you can
change the entry for a particular winery by positioning the
indicator and pressing `S' or `C'.
Return to the District list by pressing `Esc'.
When you have finished trying out the Cross Reference
panels, press `Esc' until you return to the Wine Search
Menu - the VINO:FILE entry screen.
2.5.15. QUITTING VINO:FILE
When you have finished this Guided Tour of VINO:FILE's main
functions you can return to DOS in the same way you will
end all of your VINO:FILE sessions.
From the `Wine Search', `Wine List' or `Bottle List'
screens press Alt-Q, and then Enter to confirm. On the
Wine Search panel only you can also press the `Esc' key to
Quit.
If you have made changes to the wine database or the cross
reference file then you will be asked whether you want to
save them before quitting - if you are just playing around
then you will want to enter `N' to these questions - but
normally you should save your changes when you exit.
If you want to resume your VINO:FILE session without
quitting or saving the files, you can press `Esc'.
We hope that you have found VINO:FILE Cellar Master easy to
use and that it provides all of the functions that you need
to manage your own cellar or tasting notes.
For more information on a particular function see the
`General Information' and `User Reference' sections of this
manual and remember - if you need help while using
VINO:FILE you can press `F1' from just about any panel.
---------------------------------------------------------------
Section II. Getting Started Page 28 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
SECTION III. GENERAL INFORMATION
3.1. COMMAND LINE PARAMETERS
To start VINO:FILE from the command line enter the
following:
VF [drive:] [directory\] [filename]
[ {/C /L /M} {/0 /2 /4 /5} /E /X /B ]
What all this means is that after the name of the program
(VF) you may OPTIONALLY enter the name of the wine database
to load and then one or more configuration parameters.
If you do not enter a database name then VINO:FILE will
load the database that you have entered on the `Change
Configuration' panel. If you have not yet set up or
changed your configuration then a database called WINE will
be loaded if it exists. You do not need to enter the
extension which is always `.DBA' for wine database files.
If VINO:FILE cannot find the database you have specified
(on the command line or the configuration file) it will ask
you whether you want to create a new database with that
name or abandon the load. If you press `ESC' you'll be
returned to DOS.
The command line configuration parameters are as follows:
. /C /L or /M Video Mode (Choose one only)
You will not need to specify a video mode
unless the default colors (/C) are
unreadable on your computer. /L installs
an alternative color set that should be
more readable on some gray-scale monitors
such as laptops. If that is still not
readable then enter /M for Mono.
. /0 /2 /4 or /5 Screen Size (Choose one only)
VINO:FILE will automatically support
screen sizes larger than the normal 80
columns by 25 rows. To force VINO:FILE
to run in 80x25 mode enter /2. EGA and
VGA monitors have a 43 or 50 line mode -
the parameters /4 or /5 will force
VINO:FILE to use that mode. If you want
VINO:FILE to use the mode the video is
already in specify /0 (the default).
. /E Specifies that VINO:FILE should NOT use
Expanded (EMS) Memory even if it is
installed on your system.
---------------------------------------------------------------
Section III. General Information Page 29 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
. /X Specifies that VINO:FILE should NOT use
Extended (XMS) Memory even if installed.
. /B Disable Brightness. VINO:FILE uses video
functions that could result in extraneous
blinking on some systems. Use this
parameter to turn off these functions.
All of these parameters can be permanently set using the
`Change Configuration' option on the `Summary Menu' - see
`Change Configuration' on page 22 for details.
3.2. SYSTEM PLATFORMS
VINO:FILE Cellar Master is written for the DOS operating
system. It has been tested on versions of MS-DOS and PC-
DOS from 2.2 through 5. Support for any future versions of
the DOS operating system should not be a problem - but
cannot be guaranteed, of course.
There are several DOS-based user interface platforms that
have become common in recent times - such as Microsoft
Windows and DESQview from Quarterdeck Office Systems.
Support for these platforms is built into VINO:FILE.
Compatibility with Ultravision and the OS/2 DOS box is also
included.
3.2.1. MICROSOFT WINDOWS
Although it is not a `Windows Program', VINO:FILE will run
as a Full Screen DOS program under Windows. In 386
Enhanced Mode you can run it either Full Screen or in a
Window.
For your convenience the VINO:FILE package includes the
file VF.PIF (a Windows Program Information File) and VF.ICO
(a Windows Icon). Copy both of these files to your Windows
Directory.
When adding VINO:FILE to the Program Manager you should
enter VF.PIF where prompted for the `Command Line'. Then
choose the `Change Icon' button and enter VF.ICO as the
`File Name'. You can use the Windows PIF Editor to change
the directory name if you have not installed VINO:FILE in
the default directory C:\VINOFILE.
---------------------------------------------------------------
Section III. General Information Page 30 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
3.2.2. DESQVIEW
DESQview is another multi-tasking platform that allows you
to run multiple DOS programs at the same time. VINO:FILE
is `DESQview aware' and needs little customization to work
with this program.
There is one limitation - VINO:FILE requires a minimum of
445,000 bytes of RAM memory to run and DESQview cannot
always provide that much memory. This should not be a
problem on 80386 or i486 systems where DESQview runs in
conjunction with Quarterdeck's QEMM memory manager.
However, on 80286 processors or less it may not be possible
to obtain enough free memory in a DESQview window to run
VINO:FILE.
You can run VINO:FILE in a small window but you will find
that it is better to have the program start in full screen
mode.
You will need to use DESQview's `Add Program' function and
set the following values on the first screen:
Memory Size (in K) 445
Program VF.EXE
Parameters
Directory your directory
Writes text directly to screen N
Displays Graphics Information N
Virtualize text/graphics (Y,N,T) N
(`Y' on some 80286 systems)
Uses Serial Ports (Y,N,1,2) N
Requires floppy diskette N
On the Advanced Options screen, set the `Maximum Program
Memory Size (in K)' to 640. You should also set `Uses its
own colors' to `Y'. All other values can use the defaults.
3.2.3. OS/2
OS/2 is an operating system that allows DOS programs to run
in a compatibility box (up to Version 1.3) and in multiple
windows (Version 2.0). VINO:FILE has been tested under IBM
OS/2 Versions 1.3 and 2.0 and no problems have been
detected.
However, we cannot guarantee support for this operating
environment. The performance of DOS under the OS/2
operating system in Version 1.3 can occasionally be
unpredictable, and Version 2.0 is still in beta test at the
time of writing.
---------------------------------------------------------------
Section III. General Information Page 31 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
3.2.4. ULTRAVISION
Ultravision and Laptop Ultravision by Personics Corporation
are highly recommended products that extend the capability
of some EGA and VGA video monitors. (Note: not all
monitors are supported, refer to the Ultravision
documentation for details.)
These products allow you to display more than the usual 25
rows by 80 columns of information on your screen and to
replace the default screen font and colors with others of
your choice. Ultravision high resolution modes are
generally more readable and easy on the eyes than the
standard DOS screens.
VINO:FILE will automatically detect any of the Ultravision
modes and re-format its panels to take advantage of these
high resolution screens. Make sure that you have
VINO:FILE's Screen Size option set to Default on the
Change Configuration panel.
3.3. MERGING SAMPLE CROSS REFERENCE FILES
The VINO:FILE diskette contains four sample Cross Reference
files. The file WINE.XRF, which you used in the Guided
Tour, contains a small sample of wineries from around the
world.
The other three files include many more wineries from
Australia (AUSSIE.XRF ), Europe (EUROPE.XRF) and North
America (USA.XRF) . To save you even more typing when
making entries you can merge one or more of the other
samples into the WINE.XRF file.
Each of these files is quite large. To save loading time
when you start VINO:FILE you should only merge the files
for areas where you often purchase wine.
To merge the USA.XRF sample into your WINE.XRF file:
. Start VINO:FILE and make sure the WINE.XRF is
loaded as the XRef file;
. Choose `Open New XRef' on the XRef Menu;
. Change `Load Option' to MERGE using the space bar;
. Type USA as the new filename and press Ctrl_Enter;
. Save WINE.XRF by selecting `Save XRef' on the XRef
Menu.
Your XRef will now contain entries for most of the major
wineries in the United States.
If you also often purchase wines from Europe and/or
Australia then you should repeat the process with the other
sample Cross Reference files.
---------------------------------------------------------------
Section III. General Information Page 32 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
3.4. SCREEN LAYOUT AND DATA ENTRY
The screens in VINO:FILE Cellar Master are designed so
that, as far as possible, you use the same keys for the
same function throughout the program. There are several
types of panel used in VINO:FILE.
The following are common to all of the panels:
. F1 will display a context-sensitive Help
Panel. All non-trivial panels in
VINO:FILE have help panels available;
. Esc cancels any input and returns to the
previous panel;
. Ctrl_Enter accepts all input and displays the next
panel.
The panels do not always fill up the whole screen. Some
panels are pop-up windows that overlay another panel on the
screen. The key functions described here are the same for
both types.
3.4.1. USING THE MOUSE
VINO:FILE allows you to do everything with the mouse that
you can do from the keyboard - except for entering your
data.
If you have a mouse and wish to use it with VINO:FILE all
you have to do is make sure you have loaded the mouse
driver before you start the program. The mouse cursor
displays as a white diamond on a red square and will move
around the screen as you move your mouse.
If the mouse is not working check the `Use Mouse' parameter
on the `Change Configuration' screen. If setting this to
`Y' still does not fix your problem then you probably need
to load the DOS mouse driver by adding the line
DEVICE=C:\MOUSE.SYS
to your CONFIG.SYS file. You will find complete
instructions in the documentation supplied with your mouse.
To perform the common actions noted above with your mouse:
. HELP for help, click on the section of the
Status Line where you see `F1:Help';
---------------------------------------------------------------
Section III. General Information Page 33 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
. CANCEL to cancel any input on the current panel
and return to the previous panel press
the right button on your mouse;
. ACCEPT to accept all input on the current panel
and display the next panel, click on the
Status Line where you see `Ctrl_ENTER :
Accept'.
3.4.2. STATUS LINE
On the bottom line of the screen is the `Status Line'. The
status line displays error messages and also gives brief
instructions for the panel currently displayed.
Where there is a list of action keys or function keys you
can click on that part of the status line to perform that
action at any time. Clicking on informational messages
will have no effect.
3.4.3. DATA ENTRY PANELS
Most of the screens in VINO:FILE ask you to enter data
about wines, bottles of wine or Cross Reference
Information. These data entry panels consist of a number
of fields in which you can enter the relevant data values.
Each field is indicated by `==>` on the screen. The name
of the field is on the left of the `==>` and you enter the
value of the field to the right of it. You will see a
blinking cursor in the current field. When you have
finished entering values, press Ctrl_Enter (press the Ctrl
and Enter keys together) to accept the data.
The following sections describe the editing commands that
you can use in the data fields.
Use the following keys to move from field to field:
. Enter accepts any data typed by the user and
moves the cursor to the next field;
. Tab moves the cursor to the next field;
. Shift_Tab moves the cursor to the previous field;
. Down_Arrow moves the cursor to the field directly
below the current field;
. Up_Arrow moves the cursor to the field directly
above the current field;
. PgUp moves to the first field on the panel;
---------------------------------------------------------------
Section III. General Information Page 34 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
. PgDn moves to the last field on the panel;
. Esc cancels all data entered on the panel
and returns to the previous panel;
. Ctrl_Enter accepts all data entered on the panel
and displays the next panel.
You can move to any field by clicking on the data part of
it with your mouse.
Some Data Entry panels have other keys that perform special
functions on that panel only. You will find a list of
these functions either on the Status Line or on the window
frame.
3.4.4. FIELD EDITING COMMANDS
You can enter a value into a data entry field by typing it
using the normal keyboard keys.
In addition, however, there are many editing commands that
you can use to make data entry easier. Note that these
editing commands are for normal (single line) fields. The
editing commands for memo fields - fields that accept
multiple lines of input in a pop-up memo window - are given
in the following section.
Many of these editing commands are shown as `Ctrl_x' which
you enter by holding down the Ctrl key while pressing the
keyboard key `x' where `x' varies from command to command.
Normal Data Entry field editing commands:
. Left Arrow moves cursor one character to the left;
. Right Arrow moves cursor one character to the right;
. Home moves cursor to the first character;
. End moves cursor just past the last
character;
. Ctrl_Left Arrow moves cursor one word to the left;
. Ctrl_Right Arrow moves cursor one word to the right;
. Ins toggles insert mode on and off;
. Del deletes the character to the right of
the cursor;
. Backspace deletes the character to the left of the
cursor;
---------------------------------------------------------------
Section III. General Information Page 35 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
. Enter accepts entered data and move to the
next field;
. Ctrl_E erases the entire field;
. Ctrl_P restores previous or Ctrl_E(rased) field
contents;
. Ctrl_S starts editing over;
. Ctrl_T deletes word to right of cursor;
. Ctrl_Home erases all characters to the left of the
cursor;
. Ctrl_End, Ctrl_X erases all characters to the right
of the cursor.
You can also move around in a field by clicking on a
particular character position with your mouse.
There are several types of data fields. The format rules
for each field vary according to its type. A short beep
indicates that you pressed an invalid key.
. Alphanumeric you can enter any printable character.
Note that alphanumeric fields will
adjust the case of the contents. You
can select Upper Case, Lower Case, Mixed
Case or `Anything' using `Change
Configuration' on the Summary Menu.
. Integer only numbers `0' through `9' are
allowed. Some fields have limited
values - see the Help screen for that
panel for details.
. Real (Decimal) numbers `0' through `9' plus the
decimal point `.' are allowed.
. Choice Fields some fields offer a choice between
several values. To toggle forward
through the possible values press the
space bar or the `+' key. To toggle
backwards use the `-' key.
. Yes/No Fields a yes or no answer is required - you
can only press the `Y' or `N' keys.
---------------------------------------------------------------
Section III. General Information Page 36 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
. Date Fields only numbers are allowed - the date
separator character (`/', `-' or `.')
remains constant. When you press Enter
the date is checked for validity -
months must be between 1 and 12
inclusive and the day appropriate for
that month.
Note that dates are edited in either
mm/dd/yy, dd/mm/yy or yy/mm/dd format -
depending on the Date Format option in
the configuration file. Use `Change
Configuration' on the Summary Menu to
change this option.
3.4.5. MEMO FIELDS
A VINO:FILE memo field contains multiple lines of text that
you edit in a pop-up window. Examples of memo fields are
the Wine Comments, Bottle Occasion and Bottle Taste fields.
Although the length is effectively unlimited, there is an
actual limit to the length of a memo field. This defaults
to 1750 characters (around 20 lines) but can be increased
up to 32,767 characters (over 400 lines of text) on the
`Change Configuration' panel.
Initially, only the first few characters of the first line
are displayed on the data entry panel. If there is more
data, there will be three dots ( ... ) at the end of the
line.
When you move the cursor to the memo field, you can pop up
the edit window by pressing the right arrow key or by
starting to type data. You can then type the rest of the
memo text. In addition, however, there are many editing
commands that you can use to make data entry easier.
Note that these editing commands are for memo fields. The
editing commands for normal fields were given in the
previous section.
Many of these editing commands are shown as `Ctrl_x' and
are entered by holding down the Ctrl key while pressing the
keyboard key `x' where `x' varies from command to command.
Memo Data Entry field editing commands:
. Left Arrow moves cursor one character to the left;
. Right Arrow moves cursor one character to the right;
. Up Arrow moves cursor up one line;
---------------------------------------------------------------
Section III. General Information Page 37 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
. Down Arrow moves cursor down one line;
. Home moves cursor to the start of the current
line;
. End moves cursor just past the last
character in the current line;
. Ctrl_Left Arrow moves cursor one word to the left;
. Ctrl_Right Arrow moves cursor one word to the right;
. Ctrl_Home moves cursor to the start of the window;
. Ctrl_End moves cursor to the end of the window;
. PgUp scrolls up the memo window one page;
. PgDn scrolls down the memo window one page;
. Ctrl_PgUp scrolls to the top of the memo;
. Ctrl_PgDn scrolls to the end of the memo;
. Ins toggles insert mode on and off;
. Del deletes character to the right of the
cursor;
. Backspace deletes character to the left of the
cursor;
. Enter moves to the next line - or inserts a
carriage return if in insert mode;
. Ctrl_B reformats paragraph;
. Ctrl_E erases characters in current line;
. Ctrl_K_G reformats the entire memo (hold Ctrl
down while pressing `K' and then `G');
. Ctrl_N inserts a line;
. Ctrl_O_I toggles auto-indent mode (hold Ctrl down
while pressing `O' and then `I');
. Ctrl_P restores previous contents of the line;
. Ctrl_S starts editing over - current line;
. Ctrl_T deletes a word;
. Ctrl_X erases all characters to the end of the
line;
---------------------------------------------------------------
Section III. General Information Page 38 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
. Ctrl_Y deletes the current line;
. Ctrl_Enter, Esc ends editing, saving all changes.
You can also use the mouse to move and scroll around the
editing window.
The Esc key does not cancel the changes when used in a memo
field. However, if you do want to cancel any changes that
you made to the memo field you can press Esc again to
cancel all changes on the data entry panel that contained
the memo field.
For example, on the `Change Wine' panel you begin to edit
the Comments field. You realize that you are editing the
wrong wine - or have made a major mistake. Press Esc to
pop down the window and press Esc again. All changes on
the change wine panel - including the changes to the
Comments field - will be cancelled and you can start over.
Memo Edit windows can be Zoomed, Moved or Re-Sized:
. Press F2 to zoom the window - alternating between
full size and reduced size. If you have a mouse
you can also click on the Arrow symbol on the top
right corner of the frame.
. Press F3 and then use the arrow keys to move the
window around the screen. Or press and hold the
mouse button while pointing to the top line of the
frame and moving the mouse.
. Press F4 and use the arrow keys to re-size the
window. You can also press and hold the mouse
button while pointing at the symbol at the bottom
right corner and moving the mouse.
3.4.6. SPECIAL FIELDS
There are two special field types that you can take
advantage of in VINO:FILE Cellar Master - Turbo Fields and
Year Fields. Also, you can set up string fields to display
in Upper Case, Lower Case or Mixed Case.
TURBO FIELDS
In many cases, VINO:FILE can use the Cross Reference
information to make intuitive guesses about the likely
contents of fields you are typing. Producers, Districts
and Varieties are all examples.
---------------------------------------------------------------
Section III. General Information Page 39 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
These are Turbo Fields and you will often see VINO:FILE
displaying a possible value on the bottom right part of the
frame. This value always starts with the letters you have
already typed - if a match cannot be found then nothing is
displayed.
To accept the value that the Turbo Field is displaying just
press Enter and the value will be pasted into the field.
If you do not want to paste the value displayed keep typing
or put a space at the end of your data - this will disable
the Turbo Field.
You can also cycle through possible values while a Turbo
Field is active by pressing the numeric `+' and ` -' keys.
Note: Only the minus key on the numeric keypad cycles a
Turbo Field - the hyphen character key does not.
YEAR FIELDS
There is nothing worse than typing `19' in front of every
year in any application - in VINO:FILE you don't have to.
Even though year fields are stored and displayed in full 4-
digit format you only have to type the last two digits in
any year field. This includes the `Year Ready' and `Drink
By' fields.
If you enter `89' VINO:FILE will interpret that as 1989.
If you enter `01' this will be interpreted as 2001 -
although if you really did mean 1901 you can type that in
full and it will not be re-interpreted.
STRING FIELD MIXED CASE RULES
VINO:FILE allows you to have string fields displayed in
UPPER CASE, lower case, Mixed Case or displayed exactly as
entered. You set these options on the Change Configuration
panel - see page 23 for details.
If you select Mixed Case the following rules apply. A
character is capitalized if and only if:
. it is the first letter of the first word or is
preceded by a blank, period (.), slash (/) or
hyphen (-);
. or a character is preceded by a quote (') but is
not an `S'.
The following examples illustrate these rules:
Robert Mondavi B.R. Cohn Cabernet/Merlot
Gundlach-Bundschu Stag's Leap 'Martha's Vineyard'
---------------------------------------------------------------
Section III. General Information Page 40 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
3.4.7. THE MENU BAR
VINO:FILE displays the `Menu Bar' on the top line of the
screen at all times - though you can only access it from
some of the panels. From the `Wine Search', `Wine List'
and `Bottle List' panels you can access the `Menu Bar' by
pressing F10. On other panels, F10 will do nothing.
When you select the Menu Bar with F10, one of the Menu Bar
options will be highlighted in reverse video. You can
choose one of the options by using the right and left arrow
keys and pressing Enter while that option is highlighted.
This will display the sub-menu for that option.
As a shortcut you can press Alt and the first letter of the
Menu Bar option (Alt-F, Alt-A, Alt-S etc) instead of F10 -
you can still move to a different pick list using the left
and right arrows. If you have a mouse you can access the
menu bar and select menu options by clicking on the option
you want.
Each option on the Menu Bar displays a pick list of sub-
options that you select from using the Up and Down Arrow
keys. On a list of sub-options you can also press the
Highlighted letter of a particular option. The highlighted
letter is usually the first one, but not always. For
example, to save the current database from the Wine List
screen you can press Alt-F and then `S'. For `Save
Database As' you would press Alt-F and then `A'.
After you have selected an option from a sub-menu and
performed that operation you will return to what you were
doing on the Wine Search, Wine List or Bottle List screens.
This is also the case if you press `Esc' to cancel the
operation. If you would like to change this behavior you
can use Change Configuration (see page 22 for details) to
change the `Pop Menus' option to `N'. Thereafter you will
be able to back out of the menu system one step at a time.
3.4.8. HELP PANELS
Help is available on all non-trivial VINO:FILE panels by
pressing the F1 key or by clicking on the Status Line where
you see `F1:Help'. VINO:FILE Help is what is commonly
referred to as a `Context-Sensitive, Hypertext System'.
The Help Panel displayed will contain information relevant
to the current VINO:FILE panel. From there you can
navigate through the Help System to find information about
any aspect of VINO:FILE using the `Topic Index' or `Topic
Hot Spots'.
---------------------------------------------------------------
Section III. General Information Page 41 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
You can display the Topic Index by pressing the F1 key on
any Help panel. On the index you can select any of the
listed topics by moving the highlight bar with the arrow
keys and pressing Enter on the topic you would like to
view. You can also use your mouse to double click on a
topic of interest.
Embedded in many of the Help panels are Topic Hot Spots.
These areas, highlighted in reverse video, indicate that
there is further information available about that topic.
You can view that information by moving the cursor into the
highlighted area (using arrow or Tab keys) and pressing
Enter - or by double clicking on the highlighted area with
your mouse.
If there is more than one screen of help information then
you can use the arrows, PgDn and PgUp keys to scroll
through the screens. The Help Panel for the `Wine Search'
screen is shown here.
When you have finished reading the help information,
pressing Esc will return you to the VINO:FILE program.
3.4.9. SCROLLABLE LISTS
At the heart of VINO:FILE Cellar Master are the scrollable
panels - the Wine List, Bottle List and Cross Reference
List screens - so it is worth a quick look at the common
functions.
In a display window at the top of the panel are the details
showing what is being displayed in the list. For example,
at the top of the bottle list screen (shown on page 13) are
the details of the wine record that these bottles
represent.
In the lower part of the screen is the scrollable list.
Each line in the list represents one entry that you can
select by moving the highlight bar and pointer at the left
side of the screen.
Use the following keys to move the pointer:
. Tab, Up Arrow move the pointer up one line;
. Shift_Tab, Down Arrow move the pointer down one line;
. PgUp scroll up by one page;
. PgDn scroll down by one page;
. Home scroll to the top of the list;
. End scroll to the bottom of the list.
---------------------------------------------------------------
Section III. General Information Page 42 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
If you have a mouse installed you can also use the Scroll
Bar on the right hand edge of the list.
Clicking on the arrows at either end of the scroll bar will
move the pointer up or down one line. Clicking at any
point in the middle of the scroll bar will scroll to the
corresponding entry in the list. That is, clicking half
way down will scroll to the middle entry. You can also
click on the PgUp and PgDn symbols at the bottom right part
of the frame to scroll up or down by a page at a time.
With the pointer set to the desired entry, the user can
perform many actions on it. The list of action keys is on
the status line - you can press the appropriate key or
click on that part of the status line. Pressing Enter or
double clicking on an entry with your mouse is always the
same as `S' for select.
---------------------------------------------------------------
Section III. General Information Page 43 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
SECTION IV. USER REFERENCE
4.1. VINO:FILE MENU FUNCTIONS
Many of the VINO:FILE functions are covered in the Guided
Tour section beginning on page 7. The other functions are
explained in more detail here.
4.1.1. OPEN NEW DATABASE
To load a new wine database from disk choose `Open New
Database' on the Files Menu . When you select this option,
it will display a window showing the current database name
and asking you to enter two fields:
. Load Option Enter `NEW' (the default) to erase the
database currently in memory and then
load the new database. If you have made
changes to the current database since it
was last saved to disk then you will have
the option to save it before loading the
new database. Enter `MERGE' to keep the
current database in memory and add all
wines from the new database. In this
case, any EXACT duplicates (wines or
bottles with the same key fields) will be
skipped.
. New Name The name of the database to be loaded.
You can type in the name (without the
.DBA extension). If you press ENTER
without typing anything then a directory
window will be displayed. Select a
database from the list using the up and
down arrow keys and press ENTER.
Selecting the entry ``..'' and others with
<DIR> at the right hand side of the
directory list allows you to move around
the directory hierarchy to choose a
database file.
4.1.2. IMPORTING & EXPORTING TEXT FILES
You can import databases from, or export to, a plain ASCII
text file. If you want to swap data between VINO:FILE and
a word processor, spread-sheet program or another database
system you may find this useful.
---------------------------------------------------------------
Section IV. User Reference Page 44 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
4.1.2.1. IMPORT A FILE
To import a new wine database from a text file on disk
choose `Import File' on the Files Menu.
The structure of text files that you can import is covered
below. This format is very important. VINO:FILE can only
interpret text files with a certain structure - so please
read this entire section before using the Import function.
When you select Import File, a window will display showing
the current database and asking you to enter the following
fields:
. Load Option Enter `NEW' (the default) to erase the
database currently in memory and then
import the new database or `MERGE' to
keep the current database in memory and
add all wines from the import file. In
this case, any EXACT duplicates (wines or
bottles with the same key fields) will be
skipped.
. Import File Name The name of the text file to be
imported. You can type in the name -
with an extension. If you press Enter
without typing anything in the field then
a directory window will be displayed.
Select a file name from the list using
the up and down arrow keys and press
Enter.
Directory entries in the list allow you
to move around the directory hierarchy to
choose a file from another directory.
. Field Termination Character / Record Termination
Character
In the import file, VINO:FILE is
expecting to see a number of wine and
bottle records with each record
consisting of multiple fields. You need
to tell the program what characters are
going to separate the fields and records.
The defaults are Commas to separate
fields and <CR><LF> (New Lines) to
separate records. You can also use Tabs
or Semi-colons (;) as separator
characters. You must use the same
characters importing to VINO:FILE as you
did when you created the text file.
---------------------------------------------------------------
Section IV. User Reference Page 45 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
. Use and Update XRef File
When VINO:FILE reads the new wine records
from the text file it can use the Cross
Reference file to provide geographical
information about the wines - if that
information is not already in the text
file. Similarly, if the information is
in the file it can add those wineries to
the Cross Reference for future use.
Please read the `Using Cross Reference in
Import' section carefully for details on
the effects of this option.
4.1.2.2. EXPORT A FILE
To export the wine database to a text file on disk choose
`Export File' on the Files Menu. The structure of the text
file created is the same as for import files.
When you select this option, a window will display showing
the current database and asking you to enter the following
fields:
. Export File Name The name of the text file to be
created. Enter the name (without an
extension, .TXT is assumed). If that
file already exists you will be asked
whether to overwrite it.
. Field Termination Character / Record Termination
Character
VINO:FILE creates a number of records in
the text file with each record consisting
of multiple fields. You need to specify
which characters will separate fields and
records.
The defaults are Commas to separate
fields and <CR><LF> (New Lines) to
separate records. You can also use Tabs
or Semi-colons (;). If you later import
this file, you must specify the same
characters.
4.1.2.3. TEXT FILE FORMATS
When importing text files, the format of the file is very
important. If you do not follow this format exactly,
VINO:FILE will not understand the file when it tries to
import it.
---------------------------------------------------------------
Section IV. User Reference Page 46 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
In some situations, VINO:FILE may truncate the database or
even hang when trying to import a file, although normally
it will display an error message showing you the cause of
the error.
The import file consists of a number of wine records and
bottle records:
WINE RECORD 1
BOTTLE RECORD 1
BOTTLE RECORD 2
WINE RECORD 2
BOTTLE RECORD 3 etc
Each bottle record `belongs' to the wine record that
precedes it. So bottle records 1 and 2 both represent
bottles of Wine 1 in the example above. Like the bottle
records in VINO:FILE databases, each bottle record can
represent a number (1 to 999) of actual bottles.
You must separate the records with a particular character -
the `Record Termination Character'. We recommend that an
ASCII New Line (which is actually 2 characters - carriage
return & linefeed) be used to separate records.
The valid termination characters are:
. <CR><LF> ASCII 13 (X`0D') followed by ASCII 10
(X`0A');
. COMMA `,' - ASCII 44 (X`2D');
. SEMI COLON `;' - ASCII 59 (X`3B');
. TAB ASCII 9 (X`09').
Each record, wine or bottle, consists of many fields.
Fields must also be separated by one of the above
characters - we recommend that you use a Comma. The field
terminator MUST be a different character to the Record
Termination character.
4.1.2.4. GENERAL IMPORT FIELD RULES
Each field may optionally be enclosed in quotes (single or
double). You MUST enclose a field in quotes if it contains
either of the termination characters - field or record
terminators - or quote characters themselves.
To place quote characters inside a quoted string you must
use double quotes. For example: "Robert Parker says
""Excellent value""." . The following is also valid:
"Robert Parker says 'Excellent value'." because the single
quote is not being used to enclose the string in this case.
---------------------------------------------------------------
Section IV. User Reference Page 47 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
Date fields are controlled by the Date Format that you have
set in `Change Configuration'. That determines whether
dates are in mm/dd/yy, dd/mm/yy or yy/mm/dd format.
Invalid dates will be trapped and an error message
displayed.
Fields generally have a maximum length. If you provide a
longer value, all characters after the maximum will be
ignored (truncated). Values less than the indicated length
are acceptable. Some fields have default values that apply
if you do not supply one. You can omit fields at the END
of the record. If a record ends before all field values
have been found then those fields are assumed to be empty
and the defaults used, if any.
Here's an example of a valid import text file using Comma
as the Field Terminator, <CR><LF> as the Record Terminator
and mm/dd/yy dates:
W, Acacia, , Pinot Noir, 1985, Napa Valley, California,
U.S.A, DR, , , , <CRLF>
B, 10/03/87, , 750, 12, 1, 9.00, , 9.00, , , <CRLF>
W, Baileys,,Vintage Port, 1976, N.E. Victoria, Victoria,
Australia, FO, 1989, 1999, #, "Comments on this wine.
Quite Good, typical Rutherglen port. "<CRLF>
B, 12/06/86, , 750, 21, 2, 10.00, Cellar Door, 5.00, , ,
<CRLF>
B, 12/05/86,12/12/86,750, ,2,9.00,Cellar Door, ,0.0,,<CRLF>
W, Balgownie, , Cabernet Sauvignon, 1980, Central Victoria,
Victoria, AUSTRALIA, DR, , , , <CRLF>
B, 07/07/84, ,750,37,11,9.80, Mailing List,0.00, , , <CRLF>
B, 05/12/84, 06/15/84, 750, , 1, 10.95, 'RH Cellars, West',
, 15.0, , 'Full bodied. Will Last'<CRLF>
W, Beaulieu Vineyards, Rutherford, Cabernet Sauvignon,
1985, Napa Valley, California, U.S.A, DR, 1990, 1995, ,
<CRLF>
B, 02/23/89, 04/11/89, 750, , 2, 6.75, SAFEWAY, , 17.5,
"Dinner Party with Fred and Jane. (Roast Spatchcock).",
"Excellent, full-bodied blackberry fruit flavors.
Elegant and classy, great drinking now but should improve
up to 7 years."<CRLF>
4.1.2.5. IMPORT WINE RECORD FORMAT
Wine records contain 18 fields. All fields are
alphanumeric unless indicated. Values longer than the
indicated length will be truncated. Values less than the
indicated length are acceptable. All import fields are
directly imported to the fields of the same name in the
VINO:FILE wine record.
---------------------------------------------------------------
Section IV. User Reference Page 48 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
FIELD NAME LENGTH DESCRIPTION
. Record Type Code 1 Constant. Must be `W'.
. Company 30 Name of winery or shipper.
. Other Info 30 Additional Info about the wine.
. Variety 20 Grape variety.
. Year 4 Vintage Year.
. District 30 Geographical district.
. State 20 Geographical state.
. Country 20 Geographical Country.
. Category 2 Type of wine.
. Year Ready 4 Year to start drinking the wine.
. Drink By 4 Expected life of the wine.
. Flag 1 Any character. Default - blank.
. User 1 20 User defined field.
. User 2 20 User defined field.
. Rating 1 5 Wine rating - format 999.9 (max
100).
. Rating 2 5 Wine Rating - format 999.9 (max
100).
. Rating 3 5 Wine Rating - format 999.9 (max
100).
. Comments Unlimited length comments field.
Must be in quotes.
---------------------------------------------------------------
Section IV. User Reference Page 49 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
4.1.2.6. USING CROSS REFERENCE IN IMPORT
If you select the `Use and Update XRef' option then
VINO:FILE will use the Cross Reference file to provide
District, State and Country field defaults. In addition,
if District, State and Country fields are provided in the
text file then they will be added to the XRef file if not
already there.
The rules are (D=District, S=State, C=country, . = no
value):
+----------+-----------------------+----------------------+
| Import | Wine is in XRef | Wine is NOT in |
| Record | | XRef |
| Contains | | |
+----------+-----------------------+----------------------+
| D S C | Do nothing. Use | Add Wine to |
| . C S | provided values. | XRef using the |
| . C . | | provided values. |
+----------+-----------------------+----------------------+
| . . . | Use values from | Do nothing. |
| | the XRef file. | |
+----------+-----------------------+----------------------+
| D . . | If district exists | If the district is |
| D . C | in the XRef then use | not known then use |
| | the XRef state & | provided values. If |
| | country. | the district exists |
| | | in the XRef then add |
| | | the wine to the XRef |
| | | using the XRef state |
| | | & country. |
+----------+-----------------------+----------------------+
| . . S | If state exists in | If the State exists |
| | the XRef then use | in the XRef then add |
| | the XRef country. | the wine to the XRef |
| | If the state is not | using the XRef |
| | known then use | country. |
| | provided values. | |
+----------+-----------------------+----------------------+
If the Cross Reference file is updated when importing
files, bad and incomplete entries (and mis-spellings) can
be added to the Cross Reference and the Wine Database
records. You should check all records immediately
afterwards and correct any errors.
---------------------------------------------------------------
Section IV. User Reference Page 50 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
4.1.2.7. IMPORT BOTTLE RECORD FORMAT
Bottle records contain 12 fields. All fields are
alphanumeric unless indicated. Values longer than the
indicated length will be truncated, values less than the
indicated length are acceptable. All import fields are
directly imported to the fields of the same name in the
VINO:FILE bottle record.
FIELD NAME LENGTH DESCRIPTION
. Record Type Code 1 Constant. Must be `B'.
. Purchase Date 8 MM/DD/YY or DD/MM/YY or
YY/MM/DD according to the
current configuration
settings.
. Date Consumed 8 MM/DD/YY or DD/MM/YY or
YY/MM/DD according to the
current configuration
settings. Default - no date.
. Size 4 Integer. Size of bottle.
. Location 8 Cellar location.
. Number 3 Integer. Number of bottles.
. Cost 6 Real. Default - 0.
. Origin 20 Source of bottle.
. Value 6 Real. Default - if not
consumed, same as cost.
. Points 5 Real (999.9). Default - 0, Max
100.
. Occasion No limit
Occasion when these bottles
were consumed. Must be in
quotes.
. Tasting Notes No limit
Tasting notes for these
bottles. Must be in quotes.
Note - if there is no `Date Consumed' then the bottles will
be considered still in the cellar. Therefore the Points,
Occasion and Tasting Notes fields will be ignored.
---------------------------------------------------------------
Section IV. User Reference Page 51 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
4.1.3. SHELL TO DOS
If you want to enter normal DOS commands or run another
program without quitting VINO:FILE then you can choose
`Shell to DOS' from the Files Menu.
VINO:FILE will be temporarily suspended and the DOS prompt
is displayed. It is wise to save your Wine Database and
XRef files before shelling to DOS.
Do not start any TSR's or run any `system' utilities that
directly modify the disk drive while shelled - this would
include Disk Defragmenters, Directory Sorters, Un-delete
utilities and so forth.
When you have finished entering DOS commands and want to
return to VINO:FILE you must type `EXIT' at the DOS prompt.
VINO:FILE uses an advanced technique to swap itself out of
memory when shelling to DOS - so you have almost all of the
DOS memory at your disposal when shelled. When you `EXIT'
back to VINO:FILE the program will be swapped back in.
If you have EMS (Expanded) or XMS (Extended) memory
available in your computer then VINO:FILE will swap itself
into that memory. If you do not have EMS or XMS then
VINO:FILE will swap to your hard disk - you will need to
have approximately 600Kb of free space on your disk.
If VINO:FILE cannot find either EMS, XMS or enough free
space on disk then it will not allow you to shell to DOS.
4.1.4. ADD TASTING NOTES
Quite often you will taste wines that are not part of your
cellar - at a restaurant or a tasting group, perhaps - but
you still want to keep the tasting notes as part of your
VINO:FILE database. It does not make much sense to enter
them to the cellar using `Add Wines' and then have to go
straight to the Bottle List and `Drink' the wine.
Instead, select `Add Tasting Notes' from the Add Menu.
You will first enter the wine details as usual - this panel
is the same as when you select `Add Wines'.
After you have entered these details the Add Tasting Notes
panel will be displayed instead of the normal Add Bottles
screen.
On this panel you enter the usual bottle records for a wine
that has been consumed - the Date Consumed, Occasion,
Tasting Notes and Points - at the same time as the purchase
information. This single step saves a lot of time.
---------------------------------------------------------------
Section IV. User Reference Page 52 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
You can change the Number, Purchase Date, Cost and Origin
on the Add Tasting Notes panel but the Location and Value
Fields cannot be altered as they are not relevant when the
wine is not in the cellar.
4.1.5. RESTORE DELETED WINES
If you mistakenly delete wines or bottles from the database
you can restore them - in the same VINO:FILE session only -
by selecting `Restore Deleted Wines' from the Add Menu.
To test this feature, make sure that you have deleted at
least one wine or bottle record, press Alt_A and select
this option.
VINO:FILE will display a list of the deleted wines. This
list works like the main Wine List, however the only line
commands available are:
. S or Enter Display the bottle list;
. R Restore this wine and its bottles to the
cellar;
. F Find a particular wine in the list;
When you display the bottle list you will be able to
select:
. S or Enter Display fields for this bottle (browse
only);
. R Restore just this bottle record to the
cellar.
4.1.6. BROWSE DELETED BOTTLE PANEL
The Browse Deleted Bottle panel is available only from the
Deleted Bottles List and allows you to view the field
values for the selected bottle record (and associated wine
record). You cannot change any of the field values on this
panel.
You can browse the memo fields, if present, by pressing the
following keys:
. F2 Wine Comments field;
. F4 Bottle Occasion field;
. F5 Bottle Tasting Notes field;
---------------------------------------------------------------
Section IV. User Reference Page 53 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
4.1.7. SHOW CELLAR STATISTICS
Choose `Show Cellar Statistics' on the Summary Menu to
analyze the contents of your cellar. The Choose Statistics
Fields panel is displayed and you can enter the following
fields. All field values are toggled by pressing the space
bar or the `+' and `-' keys.
. Analyze You can analyze the entire database, the
cellar or the current wine list.
Analyzing the `Database' will include all
wines that have ever been entered,
`Cellar' only the wines that have not
been consumed, and `List' the currently
displayed Wine List.
. Primary Field, Secondary Field
You can choose one or two wine record
fields to use as the basis for your
analysis. The database will be divided
into categories based on those fields and
VINO:FILE will count the number in each
category.
There are three special fields that are
not actually part of the Wine Record.
`Cellar Location' is obvious. `Optimum
Drink Date' is the midway point between
the `Year Ready' and `Drink By' values.
`Year in Ready Range' will match all
years between the `Year Ready' and `Drink
By' fields inclusive.
There is a restriction - you cannot
specify any Secondary Field if the
Primary Field is either `Cellar Location'
or `Year In Ready Range'.
. Sort Order The Statistics List can be ordered by
Field (the combined Primary and Secondary
Fields) or by Number (the number in each
category).
. Count You can count the number of `Wines' in
each category, `Bottles' - the number of
bottles, including those that have been
consumed, or `Bottles In Cellar' - the
number of bottles in each category that
are not yet consumed. Note that you
cannot count wines if Cellar Location is
the Primary or Secondary field.
---------------------------------------------------------------
Section IV. User Reference Page 54 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
After choosing these parameters, press Ctrl_Enter to
display the statistics.
This shows the statistics for the entire Sample database -
by Wine Category and Year. You can see the number of Dry
Red (DR), Dry White (DW), Fortified (FO) and Methode
Champenoise (MC) bottles of wine by vintage year. You can
display the statistics in Tabular or Graphic format.
Switch between formats by pressing the F3 key.
To print a statistics report , press F2. The printout can
be in either Tabular or Graphic format depending on the
current display format.
4.1.8. MEMORY USAGE SUMMARY
To display statistics on system memory choose `Memory
Usage' on the Summary Menu . This screen is basically for
debugging purposes but may also be of interest to some
users.
The meanings of the various fields are as follows:
. Total Memory Available the number of bytes of memory
free after VINO:FILE has started
up.
. Overlay Buffer Size the amount of memory that
VINO:FILE uses to buffer its
overlay files. This is generally
150,000 bytes but will be reduced
- at the cost of performance -
when memory is limited.
. Memory Now Used by VINO:FILE
The total RAM memory used by
VINO:FILE for internal structures,
screen buffers, and data.
. Memory Used for Wine Database
Information on memory use for
storage of the Wine Database. The
first figure is the amount of RAM
memory used for miscellaneous
database structures.
The next three lines show the data
structures that are used for the
Wine Records, Bottle Records and
Text Records respectively.
---------------------------------------------------------------
Section IV. User Reference Page 55 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
. W: 10984, and 8806 / 10948 in RAM
indicates that, for Wine Records,
10948 bytes have been reserved in
RAM and 8806 bytes are in use.
The first figure is the total
amount of RAM - in this case it
includes the main storage. If
main storage is in EMS, XMS or
Disk there is still some RAM used
for overhead.
. Memory Used for XRef is in the same format as for the
Wine Database above.
. Memory Free for Use by Wine/XRef
VINO:FILE reserves some RAM for
internal use. This is the amount
of memory available for the
Database and Cross Reference.
. Maximum RAM for Array Buffers
The amount of RAM that is allowed
for each of the database data
structures (Wines, Bottles and
Texts) and the XRef. If more is
needed then EMS, XMS or Disk
Virtual Storage is used allowing
each structure to be far bigger
than the amount of free RAM.
. Actual / Max Memory Free the total amount of free RAM
and the size of the largest free
block.
. Total Expanded Memory Installed
The amount of EMS (Expanded)
memory that is defined in your
system. If you specified the /E
parameter when you started
VINO:FILE then the Expanded memory
will NOT be used and is noted with
(*).
. EMS Now Available The amount of EMS (Expanded)
memory now available.
. Overlay File in EMS If EMS is installed the overlay
file is loaded there to improve
swapping times. This usage of EMS
is NOT affected by the /E command
line parameter.
---------------------------------------------------------------
Section IV. User Reference Page 56 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
. XMS Now Available to VINO:FILE
The amount of XMS (Extended)
memory that is now available. If
you specified the /X parameter
when you started VINO:FILE then
the Extended memory will NOT be
used and is noted with (*).
4.1.9. OPEN A NEW CROSS REFERENCE
To load a new Cross Reference file from disk choose `Open
New XRef' on the XRef Menu. When you select this option, a
window displays showing the current Cross Reference file
and asking you to enter two fields:
. Load Option Enter `NEW' (the default) to erase the
Cross Reference currently in memory and
then load the new Cross Reference file.
If you have made changes to the current
XRef since it was last saved to disk then
you will have the option to save it
before loading the new file.
Enter `MERGE' to keep the current Cross
Reference in memory and add all entries
from the new Cross Reference file. In
this case, any EXACT duplicates will be
skipped.
. New XRef Name The name of the Cross Reference file to
load. You can type in the name (without
the .XRF extension). If you press Enter
without typing anything in the field then
a directory window will be displayed.
Select a Cross Reference file from the
list using the up and down arrow keys and
press Enter.
The directory entries in the list allow
you to move up the directory hierarchy to
choose a Cross Reference file from
another directory.
---------------------------------------------------------------
Section IV. User Reference Page 57 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
4.1.10. PRINT A CROSS REFERENCE REPORT
Choose `Print XRef' on the XRef Menu to print reports on
all entries in the current Cross Reference file.
Displayed on the second line is the current printer setup
information (such as `HPLJ to LPT1') which shows the type
of formatting and where to direct the output. To change
this, choose `Printer Setup' on the Print Menu.
THE FIELDS THAT YOU ENTER ON THE PRINT XREF PANEL ARE:
. Print By Producer / District
press the space bar to toggle the value.
The report can be ordered by Producer or
by District.
. Heading Text allows you to enter up to 40 characters
that will be printed at the top of each
page of the report.
. File Name This field is displayed only if you have
set up VINO:FILE to print to a file.
Enter a DOS filename - with extension.
4.1.11. THE VARIETY CROSS REFERENCE LIST
The Cross Reference file includes information on Grape
Varieties and Wine Categories to make data entry quicker
and easier. Any time you add a wine of a particular
variety to the database the variety will be added
automatically to the Variety list.
You can display and change this information by selecting
`Variety List' on the XRef Menu.
The Variety list displays Grape Varieties and the Wine
Category usually produced from that variety. It is
scrollable using the Up and Down arrow keys, PgUp and PgDn
and the scroll bar if you have a mouse.
You can perform the following actions on each entry:
. A Add a new Variety
. S or C Change a Variety
. D Delete a Variety
. F Find a particular variety in the list.
Remember to specify the Category when adding or changing a
variety.
---------------------------------------------------------------
Section IV. User Reference Page 58 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
4.2. THE VINO:FILE DATABASE STRUCTURE
The VINO:FILE database is kept in memory while VINO:FILE is
running. If VINO:FILE cannot obtain enough normal RAM to
store the database it will automatically use EMS (Expanded)
Memory, XMS (Extended Memory) or a disk file to store some
or all of the data.
4.2.1. RECORD STRUCTURES
The database contains three classes of records - wine
records, bottle records and text records. Fields in the
records which are used internally by VINO:FILE are not
shown here.
Each wine in the database is kept in a WINE RECORD and
identified by a unique key consisting of the following
fields (in sort order):
. Producer Alphanumeric, 30 characters;
. Other Info Alphanumeric, 30 characters;
. Variety Alphanumeric, 20 characters;
. Year Alphanumeric, 4 characters.
Fields in the wine record that are not part of the key but
which the user can enter and change are:
. District Alphanumeric, 30 characters;
. State Alphanumeric, 20 characters;
. Country Alphanumeric, 20 characters;
. Category Alphanumeric, 2 characters;
. Year Ready Alphanumeric, 4 characters;
. Drink By Alphanumeric, 4 characters;
. Flag Alphanumeric, 1 characters;
. User 1 Alphanumeric, 20 characters;
. User 2 Alphanumeric, 20 characters;
. Rating 1 Real, format 999.9, maximum 100;
. Rating 2 Real, format 999.9, maximum 100;
. Rating 3 Real, format 999.9, maximum 100;
. Comments A text memo.
---------------------------------------------------------------
Section IV. User Reference Page 59 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
Each wine record contains a pointer to a list of BOTTLE
RECORDS. Each bottle record represents one or more bottles
of that wine and identified by a unique key consisting of
the following fields (in sort order):
. Drink Date Date;
. Purchase Date Date;
. Size integer, format 9999;
. Location alphanumeric, 8 characters.
Fields in the bottle record that are not part of the key
but which the user can enter and change are:
. Number integer, format 999;
. Cost real;
. Origin alphanumeric, 20 characters;
. Value real;
. Occasion a text memo;
. Taste a text memo;
. Points real, format 999.9, maximum 100.
All TEXT MEMO fields (wine comments, bottle occasion and
tasting notes) consist of a pointer to a list of text records
each containing up to 70 characters. When edited, they are
spooled as a single string in a text buffer.
4.2.2. DATABASE CAPACITY
VINO:FILE keeps as much of the database in RAM memory as
possible at all times - in order to ensure that operation
remains as fast as possible. At least part of the database
is always in memory. Therefore there is always a limit to
the capacity of any one database.
VINO:FILE can store parts of the database in RAM Memory,
Expanded (EMS) Memory, Extended (XMS) Memory and in Disk
Files at any time depending on the amount of each memory
type available. The database can be split with some
records in each type of memory - it does not have to be all
in RAM or all in Expanded, for example.
All of these types of memory are also used to store the
Cross Reference and so the size of your Cross Reference
will also affect the database capacity.
---------------------------------------------------------------
Section IV. User Reference Page 60 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
Note also that each user will have different numbers of
bottle records per wine, and very different numbers of text
records depending on how verbose the Wine Comments, Bottle
Occasion and Tasting Notes are.
Because of this it is not possible to state an exact
maximum number of wines or bottles of wine that you can
keep in the database. The following values are VERY
APPROXIMATE and may not be accurate for your particular
system.
IF YOU DO NOT HAVE ANY EMS OR XMS:
If your system does not have any expanded or extended
memory then VINO:FILE can store the database only in RAM
Memory or on Disk.
The performance of the system will be better when the
database is stored in RAM but not significantly so unless
the database is very large.
Although we can usually assume that disk space itself is
unlimited, VINO:FILE needs to keep buffers and disk usage
records in RAM and therefore the capacity of the database
when stored on disk is sometimes lower than you might
expect.
The following table shows the number of different wines
(not bottles) you can expect to store in a database stored
in RAM or on Disk. Note the assumptions that follow the
table as these will vary widely between different users.
+----------+-------------+--------------+--------------+
| | Total RAM Available |
| Where | (see Memory Usage Summary) |
| Stored +-------------+--------------+--------------+
| | 270,000 | 220,000 | 190,000 |
+----------+-------------+--------------+--------------+
| RAM | 120 Wines | 80 Wines | 55 Wines |
+----------+-------------+--------------+--------------+
| DISK | 3,250 Wines | 2,250 Wines | 1,500 Wines |
+----------+-------------+--------------+--------------+
Assumptions: Each Wine Record has 3 Bottle Records;
there is one line of Comments per two
wine records; there is one line of
Occasion or Tasting Notes per two bottle
records.
---------------------------------------------------------------
Section IV. User Reference Page 61 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
IF YOU DO HAVE EMS OR XMS:
If your system has expanded or extended memory then
VINO:FILE will always use this in preference to storing the
database on disk. The performance of the system will be
almost as fast with the database in EMS or XMS as it is in
RAM.
When the database is in EMS or XMS there is still some RAM
storage required but the RAM requirements are less than
with any other storage method.
Therefore the database capacity is greatest if you have EMS
or XMS available to VINO:FILE.
The following table shows the number of different wines
(not bottles) you can expect to store in a database stored
in EMS or XMS.
+----------+-------------+--------------+--------------+
| | Total RAM Available |
| | (see Memory Usage Summary) |
| +-------------+--------------+--------------+
| | 270,000 | 220,000 | 190,000 |
+----------+-------------+--------------+--------------+
| # WINES | 6,000 Wines | 4,250 Wines | 3,000 Wines |
+----------+-------------+--------------+--------------+
| EMS/XMS | 2,980 Kb | 2,110 Kb | 1,490 Kb |
| Required | | | |
+----------+-------------+--------------+--------------+
Assumptions: Each Wine Record has 3 Bottle Records;
there is one line of Comments per two
wine records; there is one line of
Occasion or Tasting Notes per two bottle
records.
The amount of RAM is no longer an issue when the database
is stored in EMS or XMS, however the EMS / XMS requirements
for these maximums are quite large. Let's state the
capacity another way:
If you have 650,000 bytes of EMS or XMS free when
starting VINO:FILE you can easily process a database
containing over 1,000 different wines, 3,000 bottle
records and 1,000 lines of text. The more EMS or XMS
available, the larger the database can be.
As you can see, the use of either expanded or extended
memory allows VINO:FILE to comfortably handle the
management of extremely large cellars.
---------------------------------------------------------------
Section IV. User Reference Page 62 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
INDEX
Use in Import, 50
A Variety List, 58
Currency Format, 22
Adding
Bottle Records, 18 D
Tasting Notes, 14, 52
Wine Records, 15 Data Fields
Editing, 35
B Turbo Fields, 39
Two-Digit Years, 40
Bottle List Database
Format, 12 Capacity, 60
Bottle Record Clear, 19
Adding, 18 directory list, 44
Change, 13 Export To Text File, 46
Drink, 14 Import File Format, 46
Format, 60 Import Text File, 45
Import/Export Format, 51 Merging, 44
Key Fields, 13 Record Structure, 59
Purchase Fields, 18 Sample, 5
Restore Deleted, 53 Save, 19
Tasting Notes, 13, 14, 52 Save With New Name, 19
Brightness Summary, 21
Disabling, 23 Date Format, 22
Date of Valuation, 21
C Default Print Header, 24
DesqView, 31
Capacity Directory
Database, 60 Initial Data Directory, 24
Change Disable
Bottle Records, 13 Brightness, 30
Wine Records, 19 Expanded Memory, 29
Color Set, 6, 23, 29 Extended Memory, 30
Command Line Parameters, 29 DOS
Commands Platforms, 30
Data Field Editing, 35
Field Movement, 34 E
Memo Field Editing, 37
Cross Reference Editing
AUSSIE.XRF, 32 Bottle Records, 13
Directory List, 57 Data Fields, 35
District Sub-List, 28 Memo Fields, 37
EUROPE.XRF, 32 Wine Records, 19
in Add Wines, 16 Ending VINO:FILE, 28
Listing, 26 Expanded Memory
Merging, 57 Disabling, 29
Merging Files, 32 Export
Open New, 26, 57 Database, 46
Printing Reports, 26, 58 Text File Format, 46
Record Fields, 27 Extended Memory
Sample, 6 Disabling, 30
Save, 26
USA.XRF, 32
Index Page 63 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
Pop Menus, 23, 41
F Summary Menu, 21, 54, 55
XRef Menu, 57, 58
Fields Microsoft Windows, 30
Case of Strings, 23, 40 Mouse
Configuration, 22 Disabling, 23
Cross Reference, 27 General Use, 33
Data Field Commands, 35 Scroll Bars, 11, 43
Data Field Types, 36
Memo Field Commands, 37 O
Rating Field Names, 24
Search Type, 9 OS/2
Special Searches, 9 Support, 31
Turbo Fields, 8, 39
Two-Digit Years, 9, 40 P
User Field Names, 24
Files Panel
Configuration File, 6 Add Bottles, 18
List of, 5 Add Wines, 16
Format Bottle List, 12
Currency, 22 Cellar Statistics, 54
Data Fields, 36 Change Bottle, 13
Date, 22 Change Configuration, 22
String Fields, 23, 40 Change Wine, 19
Drink Bottle, 14
H Help Panels, 41
Sort Wine List, 21
Help Panels, 41 Variety List, 58
Wine List, 10
I Wine Search, 7
XRef List, 27
Import Platforms
Database, 45 DesqView, 31
Text File Format, 46 Microsoft Windows, 30
Using Cross Reference, 50 OS/2, 31
Installation Program, 5 Ultravision, 32
Printing
M Bottle Details, 25
Cancel Printout, 26
Memo Fields Cross Reference, 26, 58
edit buffer size, 22 Default Header, 24
Editing, 37 Heading Text, 26
Moving, 39 Printer Port, 25
Re-sizing, 39 Printer Setup, 25
Zooming, 39 Printers Supported, 25
Memory Sort Order, 26
Capacity, 60 Statistics Report, 55
Expanded (EMS), 29, 52, Wine Details, 25
56, 60
Extended (XMS), 30, 52, Q
57, 60
Requirements, 2 Quitting VINO:FILE, 28
Menu
Add Menu, 20, 52, 53 R
Files Menu, 19, 44, 45,
46, 52 Rating Fields
---------------------------------------------------------------
Index Page 64 VINO:FILE Cellar Master - Version 3 - July 1, 1992
---------------------------------------------------------------
Changing Name, 24 Windows
Requirements Microsoft Windows, 30
Memory, 2 Wine List
System, 2 Action Keys, 11, 13
Restore Format, 10
Deleted Bottles, 53 Horizontal Scrolling, 11
Deleted Wines, 53 Statistics, 54
Summary, 21
S Wine Record
Adding, 15
Save Search Record, 24 Changing, 19
Screen Size, 23, 29, 32 Format, 59
Scrolling Import/Export Format, 48
Lists, 42 Key Fields, 15
Search Repeating, 11
Arguments, 8 Restore Deleted, 53
Optimum Drinking Period, Wine Search
10 Arguments, 8
Search Type Fields, 9 Save Record, 24
Special Search Fields, 9
Two-Digit Years, 9 Y
Wild Cards, 8
Starting Year
Initial Data Directory, 24 Drink By, 9
Initial Database, 22, 29 Optimum Drinking Search, 9
Initial XRef, 23 Two-Digit Fields, 9
Parameters, 29 Year Ready, 9
Statistics
Database Summary, 21
Summary
Database, 21
List, 21
System Requirements, 2
T
Tasting Notes
Adding, 14, 52
Turbo Fields, 8, 39
Two-Digit Years, 40
U
Ultravision, 23, 32
User Fields
Changing Name, 24
V
Valuation Date, 21
Variety List, 58
Video Mode, 6, 23, 29
W
What's New, 2
---------------------------------------------------------------
Index Page 65